![]()
SilentKaos wrote: Having some trouble with the cash mod recieving the following error Error retrieving group data DEBUG MODE SQL Error : 1064 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 'AND user_pending = 0 ORDER BY group_id ASC' at line 4 SELECT group_id FROM nuke_bbuser_group WHERE user_id = AND user_pending = 0 ORDER BY group_id ASC Line : 1219 File : functions_cash.php I have tried various ways to fix this problem and Im just to the point of ripping my hair out. Any assistance would be greatly appreciated. Posted: Tue May 29, 2007 12:46 am
admin(Mark) wrote: I am not sure why the userid is not being passed. Try placing the " . $this->user_id . " within a quote '' On line 1214 change
To:
Posted: Tue May 29, 2007 2:20 am
SilentKaos wrote: tried that it shot out this error
Posted: Tue May 29, 2007 2:29 am
admin(Mark) wrote: Do you only get errors with the mod or does the rest of your website output errors? It seems the first error has been sorted. I think you need to place all those userid within a quote ''. On line 1272 change:
To:
I think you will need to do similar with the where clauses. Posted: Tue May 29, 2007 2:37 am
SilentKaos wrote: well what it is, I had a site that had 7.4 nuke installed with 2.0.10 but was fully modded I descided to upgrade to Ravens 7.6 nuke and have installed all my mods. Now the cash mod works just fine with a test account etc. But I tried to import my users over to the new nuke_users table I get a syntax error. So I dropped the entire nuke_users table and just ran the old data nuke_users table from my past 7.4 nuke and I get an error with the cash mod. Posted: Tue May 29, 2007 2:41 am
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||