Search
Search titles only
By:
Search titles only
By:
Log in
Register
Search
Search titles only
By:
Search titles only
By:
Menu
Install the app
Install
Forums
New posts
All threads
Latest threads
New posts
Trending threads
Trending
Search forums
What's new
New posts
New ads
New profile posts
Latest activity
Free Ads
Latest reviews
Search ads
Members
Current visitors
New profile posts
Search profile posts
Contact us
Latest ads
ඕනම රටකට සෙට් වෙන CV එකක්
ErMurazor
Updated:
Saturday at 9:50 AM
Hambantota
7 Acres Beachfront Land For Sell DownSouth , PerPerch Price 420 000
1024 Digital
Updated:
Wednesday at 11:57 AM
Baseus PI LITE INDOOR CAMERA
ErMurazor
Updated:
Oct 12, 2026
Ad icon
Colombo
Hard Disk For Sale
mazza
Updated:
Oct 10, 2026
land for sale
justasking
Updated:
Oct 10, 2026
Electronics
Vehicles
Property
Search
Reply to thread
Forums
General
ElaKiri Talk!
MySQL Trigger Automatic Update
Get the App
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="MrFrog" data-source="post: 29074685" data-attributes="member: 567812"><p>If there is no error, and still it doesn't work, most probably your query inside the trigger might not return any results. You need to carefully check those conditions are satisfied . You used the same table oc_t_item_meta with two aliases m1 and m2. I can see in one condition you compare its s_value with UNIX_TIMESTAMP() while in the next condition you compare s_value with bidding_price. May be I'm missing something here, but it is hard to troubleshoot without the knowledge of the context and a proper dataset.</p></blockquote><p></p>
[QUOTE="MrFrog, post: 29074685, member: 567812"] If there is no error, and still it doesn't work, most probably your query inside the trigger might not return any results. You need to carefully check those conditions are satisfied . You used the same table oc_t_item_meta with two aliases m1 and m2. I can see in one condition you compare its s_value with UNIX_TIMESTAMP() while in the next condition you compare s_value with bidding_price. May be I'm missing something here, but it is hard to troubleshoot without the knowledge of the context and a proper dataset. [/QUOTE]
Insert quotes…
Verification
Winadiyakata thappara keeyak tibeda?
Post reply
Top
Bottom