Help please sql error in module velmysqlmoduleguests

[k_4_kelly]

everything runs quite well for me so far...beside the error message on the top of my website, it appeared after i installed.

advise please......

thanks a lot


- BEGIN LOG ENTRY: Mon Apr 2 12:16:40 GMT-0400 2007
SQL ERROR in module velmysqlmoduleguests: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(now())) - time_to_sec(last_activity_time) > 120' at line 1. Query was: DELETE FROM guests where time_to_sec(time(now())) - time_to_sec(last_activity_time) > 120
- END LOG ENTRY

Hello,

Sorry to hear you have problems. What is your MySQL server version, please?
It seems the version you are using has differences in syntax in comparison to the versions Boss Cart is compatible to. It will probably require small change in the driver file. Of course assuming it is the only syntax error...

Kind Regards,
Piotrek

[k_4_kelly]

hello,

thanks for your reply.

the version of the phpmyadmin - 2.9.0.2
and the MySQL client version: 4.1.10.

So, what should i do now?
i have no idea with the syntax.....

Hello again,

It is really adviced to update MySQL version, we run Boss Cart on MySQL 4.1.21-standard, but I guess few versions back or ahead wouldn't make a difference, but 4.1.10 is far behind... It is also a security issue. Perhaps you are able to upgrade?

I tried to find a solution to this, but I'm affraid the changes in syntax of MySQL has gone so far since your version that you might end up finding such problems every few steps of the way. So once more I suggest update.

Best Regards,
Piotrek

[k_4_kelly]

hello

thanks a lot for your prompt reply
the MY SQL is came together with the Cpanel from my hosting...

not sure if I can upgrade myself...

is this the only solution?

regards,
kel

Hello,

You cannot do it yourself. But being honest, your hosting company should really consider upgarding. Leaveing that much outdated versions of basic server services is like opening the door for those scams that want do destroy sites and servers If you consider a live shop then it is worth the effort even to change your hosting company not to loose money or business later on...

The other solution is to make the script compatibile with your version, but this would require to rewrite some of the parts of the code which we cannot afford to do right now. I can suggest you to try out olderest version of Boss Cart, which might not have this problem but this would be downgarding...

Best Regards,
Piotrek