vb.org Archive - uCash & uShop old support and thank you thread

can anyone help me with my problem please

i have a problem when 1 of my users try to acess the bank they get a database error and i get sent an email that is this

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE user SET uttpoints=uttpoints-20.000.00 WHERE userid='95'
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 '.00 WHERE userid='95'' at line 1

mysql error number: 1064

Date: Friday 21st of May 2004 03:03:36 PM
Script: http://battlering.net/forums/ushop....&shortname=bank
Referer: http://battlering.net/forums/
Username: Jolly Jolza
IP Address: Edited out

only 1 user has complained about this i tried and acessed the bank fine

U-Dox

05-24-2004 05:16 AM

ok i got that Warning thing off... now when i click the link for shop, it sayz "No actions found..."

what is the problem now?

WEForums

05-24-2004 06:08 AM

You *may* need to edit what usergroups can access it. I know that's one cause of that error.

Battle_Ring, you should remove that IP Address.

smashtheqube

05-24-2004 02:14 PM

I'm running VB 3.0.1 (I did a manual install of this, not the HTL thing) and I'm also getting the "No actions found..." message. People can earn points... but anything having to do with the ushop.php file returns that error.

(and yes, I've double checked... all of the edits are done and nothing is erroring out)

The uShop file is tripping on both places in which it is possible for the "No actions found..." response to be given. (one having to do with the $storeactions variable being empty or unset, and the other being no access to any of the available actions... when it is set up properly anyway)

can someone help? :(

Battle_Ring

05-24-2004 02:16 PM

no one knwos whats causing my problem???

U-Dox

05-24-2004 05:01 PM

Quote:

Originally Posted by WEForums

You *may* need to edit what usergroups can access it. I know that's one cause of that error.

Battle_Ring, you should remove that IP Address.

Nope I Did That And Thats Not The Problem

Any Other Suggestion?

smashtheqube

05-24-2004 05:29 PM

PHP Code:


		
			
$storeactions = unserialize($datastore['utt_store_act']);

this same line is in both ushop.php and uttstoreadmin.php... yet in ushop it doesn't return any actions... giving this "no actions found..." error. how can we fix this?

Zachery

05-24-2004 05:40 PM

Quote:

Originally Posted by smashtheqube

PHP Code:


		
			
$storeactions = unserialize($datastore['utt_store_act']);

this same line is in both ushop.php and uttstoreadmin.php... yet in ushop it doesn't return any actions... giving this "no actions found..." error. how can we fix this?

Did you run the installer? if so which one

smashtheqube

05-24-2004 05:44 PM

Quote:

Originally Posted by Zachery

Did you run the installer? if so which one

the one in the admincp folder

All times are GMT. The time now is 12:57 AM.

Page 99 of 232

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05798 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 (2)bbcode_php_printable (4)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: