vb.org Archive - Major Additions - Point Market System 3.1x

Database error in vBulletin 4.0.8:

Invalid SQL:
update user set `ucash`=ucash-2500.00000- 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 'where userid='1'' at line 1
Error Number : 1064
Request Date : Monday, February 14th 2011 @ 02:01:47 AM
Error Date : Monday, February 14th 2011 @ 02:01:47 AM
Script : http://www.vanityedge.com/forum/mark..._access&type=3
Referrer : http://www.vanityedge.com/forum/mark..._access&type=3
IP Address : 86.130.230.7
Username : Wayne
Classname : vB_Database
MySQL Version : 5.0.91-community

After adding the comma.

04wayne

02-14-2011 12:04 AM

Its actually registering the lottery purchases, but instead of going back to the same page, its giving me the database error

wreckz

02-14-2011 04:36 AM

Thanks for the update. I still get this error after adding the comma.

Error when trying to purchase a lottery ticket.
Warning: Cannot use a scalar value as an array in [path]/pointmarket/gamble_access.php on line 187

Let me know if I am doing something wrong.

Aramist

02-15-2011 01:24 AM

Hi mayhem..

I have purchased a user title glow..ok

Then i have refounded it..ok

But the glow is still there....

How can i remove the glow now?

I didn't understand isn't it intended to romove the glow when i ask for refound?

I'm so confused =(

Wizardjv

02-15-2011 02:47 AM

MySQL Error : Unknown column 'phrasegroup_pointmarket' in 'field list'
Error Number : 1054

I just want to uninstall this thing. How do you go about doing that? I get 100 errors a day and its very annoying. Is there a file I can run to remove everything you installed? Or maybe some directions that show everything you installed so I can manually remove if have to?

Aramist

02-15-2011 12:48 PM

When I click create button in paypal currency creation page, a blank page apperas and nothing more..

any clue ?

TheMayhem

02-15-2011 05:56 PM

Quote:

Originally Posted by Wizardjv (Post 2162676)

That is a beyond weird error. Did you have a partially uninstallation go bad or timeout? My advise would be to reinstall and then uninstall cause there is no way you should receive that error unless you had some kinda freakish uninstallation occur.

TheMayhem

02-15-2011 05:59 PM

Quote:

Originally Posted by Aramist (Post 2162666)

Sounds like a bug that I'll have to fix so it doesn't keep occurring.

Aramist

02-15-2011 08:18 PM

But how can I remove the glow now Mayhem?

And

Did u read my post about the paypal creation? :D

Ty in advance Dude

smirkley

02-15-2011 09:16 PM

verified the thread color expiry worked, and finally removed the thread color.

Aramist, try setting the expire days for the glow in the acp, set it for one day, and buy it again.

Doing this allowed the expiry to remove my problematic thread colors.

Might work for your problem too.

All times are GMT. The time now is 01:51 AM.

Page 158 of 223

158

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03304 seconds Memory Usage 1,745KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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: