Welcome our webmaster and SEO forum
Please enjoy the forum, contribute what you can, and wind up the Moderators!
Results 1 to 6 of 6

Thread: Help please sql error in module velmysqlmoduleguests

  1. #1
    k_4_kelly is offline Junior Member
    Join Date
    Apr 2007
    Posts
    3

    Unhappy Help please sql error in module velmysqlmoduleguests

    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

  2. #2
    Piotrek Guest

    Default

    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

  3. #3
    k_4_kelly is offline Junior Member
    Join Date
    Apr 2007
    Posts
    3

    Default

    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.....

  4. #4
    Piotrek Guest

    Default

    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

  5. #5
    k_4_kelly is offline Junior Member
    Join Date
    Apr 2007
    Posts
    3

    Default

    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

  6. #6
    Piotrek Guest

    Default

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Parse error: syntax error
    By Bagi Zoltán in forum PHP Forum
    Replies: 3
    Last Post: 11-25-2007, 03:30 PM
  2. Error gone?
    By temi in forum General Webmaster Talk
    Replies: 3
    Last Post: 09-26-2007, 11:15 AM
  3. phpld payment calculation module
    By 3wlink in forum General Webmaster Talk
    Replies: 6
    Last Post: 04-21-2007, 09:07 AM
  4. iTrader module installed
    By temi in forum General Webmaster Talk
    Replies: 2
    Last Post: 03-20-2007, 04:28 PM
  5. Daffodil Releases PHP module for Java RDBMS
    By ovi in forum General Webmaster Talk
    Replies: 0
    Last Post: 02-14-2005, 01:26 PM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124