Bug MySQL Error Shell Script

[webi]

Hi Fillip,

When trying to run the shell script for the maintenance, I get the following error.

root@svweb:/var/www/mydomain.com/dbtechscripts# php vbactivitymaint.php
Please enter the path to your vBulletin directory: /var/www/mydomain.com/html
0) Recalculate Points
Maintenance action to execute [Default=0]: 0
Recalculate Points
------------------


Recalculating points...
Bearbeite: 1
        totalpoints
        activitylevel
        albumpictures
        attachments
        attachmentviews
        post
        post_own
        thread
        threadrating
        threadratingreceived
        vmgiven
        vmreceived
        pollposted
        pollvote
        friend
        givenrep
        gottenrep
        infractiongiven
        infractionreceived
        referral
        sgmessage
        sgdiscussion
        calendarevent
        dayregistered
        lastvisit
        lastpost
        blogpost
        blogcomment
        shout
        mentionsgiven
Database error in vBulletin 4.2.2:

Invalid SQL:

                        UPDATE vbdbtech_vbactivity_points
                        SET mentionsgiven = mentionsgiven + 0,5
                        WHERE userid = '1';

MySQL Error   : 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 '5
                        WHERE userid = '1'' at line 2
Error Number  : 1064
Request Date  : Tuesday, August 5th 2014 @ 09:07:42 AM
Error Date    : Tuesday, August 5th 2014 @ 09:07:59 AM
Script        : http://
Referrer      :
IP Address    :
Username      :
Classname     : vB_Database_MySQLi
MySQL Version :

Best Regards

 

[Fillip H.]

Hi Fillip,

When trying to run the shell script for the maintenance, I get the following error.

root@svweb:/var/www/mydomain.com/dbtechscripts# php vbactivitymaint.php
Please enter the path to your vBulletin directory: /var/www/mydomain.com/html
0) Recalculate Points
Maintenance action to execute [Default=0]: 0
Recalculate Points
------------------


Recalculating points...
Bearbeite: 1
        totalpoints
        activitylevel
        albumpictures
        attachments
        attachmentviews
        post
        post_own
        thread
        threadrating
        threadratingreceived
        vmgiven
        vmreceived
        pollposted
        pollvote
        friend
        givenrep
        gottenrep
        infractiongiven
        infractionreceived
        referral
        sgmessage
        sgdiscussion
        calendarevent
        dayregistered
        lastvisit
        lastpost
        blogpost
        blogcomment
        shout
        mentionsgiven
Database error in vBulletin 4.2.2:

Invalid SQL:

                        UPDATE vbdbtech_vbactivity_points
                        SET mentionsgiven = mentionsgiven + 0,5
                        WHERE userid = '1';

MySQL Error   : 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 '5
                        WHERE userid = '1'' at line 2
Error Number  : 1064
Request Date  : Tuesday, August 5th 2014 @ 09:07:42 AM
Error Date    : Tuesday, August 5th 2014 @ 09:07:59 AM
Script        : http://
Referrer      :
IP Address    :
Username      :
Classname     : vB_Database_MySQLi
MySQL Version :

Best Regards

This is because you are using an invalid decimal separator. . is the correct decimal separator that you must use in order for this to function correctly

 

[webi]

If it is these settings, they are with the decimal . separately.


About the AdminCP I could leave the maintenance function to run successfully.

 

[Fillip H.]

In that case, you may need to adjust your language settings to use the . decimal separator.

 

[webi]

Even if I switch to English, a dot as separator is displayed.
Which language setting is that?

 

[Fillip H.]

Language Manager -> Edit Settings -> Decimal Separator is the setting that controls this.