vb.org Archive - Major Additions - ICash, Simple, stand alone point system.

I get this error when create a new topic in one of over 20 forums, some users get it every time they make a new post or create new topic.

What may be causing this issue?

PHP Code:


		
			
Database error in vBulletin 3.6.8:

Invalid SQL:

                        UPDATE vb_user
                        SET `money` = `money` + 0,15
                        WHERE userid = '3';

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 '15
                        WHERE userid = '3'' at line 2
Error Number : 1064
Date         : Thursday, November 22nd 2007 @ 11:59:33 AM
Script       : http://*****forum.net/newthread.php?do=postthread&f=12
Referrer     : http://*****forum.net/newthread.php?do=newthread&f=12
IP Address   : ***hidden***
Username     : John
Classname    : vB_Database

Alphawolf83

11-22-2007 11:48 AM

Quote:

Originally Posted by Blaine0002 (Post 1387169)

updated version coming soon. :)

Well, thanks for your work, but I'd rather like to see what changed in the newest version since I am still running an older version and am unsure either to upgrade or not. :)

fishhub

11-22-2007 05:09 PM

Quote:

Originally Posted by armstrong (Post 1024734)

what if I do this:
1. pause the forum
2. go to cpanel->phpmyadmin and rename the money field to 'vbookie_cash'
3. change icash settings (admincp->icash->'money row') to 'vbookie_cash'
4. install vbookie
5. activate forum

Unless I'm missing something, this should work, right?

I tried to simply typed in vbookie_cash in money row in admincp. But cant seem to place bets in vbookie and i get an error msg once i post replies.

Tried the above but how do i do item 2?

What is phpmyadmin? Where do i find it. Sorry, am new.TIA:o

Blaine0002

11-22-2007 11:36 PM

it might be because vbookie uses a double as its field type whereas icash uses int, this will be fixed in the next release.

fishhub

11-23-2007 11:04 AM

Quote:

Originally Posted by Blaine0002 (Post 1387795)

it might be because vbookie uses a double as its field type whereas icash uses int, this will be fixed in the next release.

Thanks for e info.

However, i set it back to Icash and tried using it. It does not show any points added upon several post. And as guest , i can donate to anyone. Am using 3.5.4. Hope someone canhelp out. TIA.

Blaine0002

11-24-2007 03:46 PM

set it to 'money' (without the 's)

reebok008

11-24-2007 08:38 PM

I get this error when create a new topic in one of over 20 forums, some users get it every time they make a new post or create new topic.

What may be causing this issue?

PHP Code:


		
			
Database error in vBulletin 3.6.8:

Invalid SQL:

                        UPDATE vb_user
                        SET `money` = `money` + 0,15
                        WHERE userid = '3';

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 '15
                        WHERE userid = '3'' at line 2
Error Number : 1064
Date         : Thursday, November 22nd 2007 @ 11:59:33 AM
Script       : http://*****forum.net/newthread.php?do=postthread&f=12
Referrer     : http://*****forum.net/newthread.php?do=newthread&f=12
IP Address   : ***hidden***
Username     : John
Classname    : vB_Database

All times are GMT. The time now is 12:47 PM.

Page 100 of 119

100

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02969 seconds Memory Usage 1,754KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: