Clan Adverts

Sponsors

CT on Facebook

Latest Product

User Box

Anonymous
38.107.179.219
Nickname:

Password:

Security Code
Security Code
Type Security Code


PND Downloads Feed

Phpnuke Downloads
How to Delete or Reset yo...
How to Delete or Reset your PHPNuke Admin Account
Lost your admin password ?  Cant login to your admin account ? This s...
Back Online & Stuff
Back Online & Stuff
Look at us with our nifty website back up and running… Seriously...
How to edit the admins in...
How to edit the admins in the forums
Here is a way to make someone admin in your forums on your Evo site. I...
Demo Splash Screen
Demo Splash Screen
Ped @ Clan Themes has released a simple splash screen entrance hack. ...
Free Phpnuke Business The...
Free Phpnuke Business Theme 6
This is the 6th Business theme for Phpnuke that Clan Themes has releas...
Tricked Out Slider
Tricked Out Slider
We have seen some great new things come out of Tricked Out News and th...

Custom Work

PHP Nuke Custom Work

www.clanthemes.com :: View topic - "admin_user_fail" error message when updating
"admin_user_fail" error message when updating

2 Replies / 1628 Views


Post new topic   Reply to topic  

   www.clanthemes.com Forum Index » PHPBB

View previous topic :: View next topic


DoC
Reputation: 89.6 Add RepSubtract Rep
votes: 5
Local time: 6:09 PM
Location: UK
uk.gif



0.20 posts per day
Medals: 3 (View more...)
Dedication (Amount: 1)
Forums Moderator
Forums Moderator
Joined: Feb 07, 2007
Last Visit: 30 Jun 2011
Posts: 394
Points: 4451 

Post "admin_user_fail" error message when updating Posted: Sun Sep 02, 2007 6:18 pm

Shop Purchases:
Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

Hey all,
I get the following error when I am trying to update Users for the Gender MOD, I use the Ravens Nuke Distro 2.10 and I was able to do this procedure a few weeks ago but for some reason is now doing this:

Admin_user_fail

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 '' WHERE user_id = 5' at line 2

UPDATE nuke_users SET user_email = **********, user_icq = '', user_website = '', user_occ = '', user_from = 'Newcastle, UK', user_interests = '', user_sig = '[img:c6f0682640]http://i11.photobucket.com/albums/a151/klocke/neocardsig2.jpg[/img:c6f0682640]', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_sig_bbcode_uid = 'c6f0682640', user_allowsmile = 1, user_allowhtml = 1, user_allowavatar = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_allow_pm = 1, user_notify_pm = 1, user_popup_pm = 1, user_lang = 'english', user_style = 1, user_timezone = 0, user_dateformat = 'D M d, Y g:i a', user_active = 1, user_rank = 1, user_gender = 1' WHERE user_id = 5

Line : 713
File : admin_users.php

You all know I am a newb when it comes to errors lol can someone help me on where to start looking?

Cheers all,

DoC
 

 
View user's profileSend private messageSend e-mail Reply with quote

topjob
Reputation: 522.1 Add RepSubtract Rep
votes: 2
Local time: 11:09 AM

usa.gif



0.04 posts per day
Medals: 0
Scripts/Coder
Scripts/Coder
Joined: Apr 05, 2007
Last Visit: 13 Mar 2010
Posts: 82
Points: 9264 

Post "admin_user_fail" error message when updating Posted: Tue Sep 04, 2007 12:31 pm

An edit to an sql statement has a typo in it. I cannot tell you which file, but you will notice the single apostrophe just before WHERE user_id = 5 in the sql dump in the error message. Recheck any recently edited files.
 

†Together, were better.† Author of Member Application and Pro Forms  
View user's profileSend private messageVisit poster's websiteMSN Messenger Reply with quote

DoC
Reputation: 89.6 Add RepSubtract Rep
votes: 5
Local time: 6:09 PM
Location: UK
uk.gif



0.20 posts per day
Medals: 3 (View more...)
Site Supporter (Amount: 1)
Forums Moderator
Forums Moderator
Joined: Feb 07, 2007
Last Visit: 30 Jun 2011
Posts: 394
Points: 4451 

Post "admin_user_fail" error message when updating Posted: Tue Sep 04, 2007 1:16 pm

Shop Purchases:
Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

OK I know this may be the cause of the problem but would changing MID in the nuke_croster_members table be having an effect in the forum? I would of thought that the MID id specific to the Clan roster module and wouldnt have any bearing on the forum. The reason I state this is because i have not edited any files in the forum for well over 2 months... ever since the sub forum tradegy!

If so i am a nub coz i didnt do a back up either! All i wanted to do was have certain people in certain positions in the Clan Roster Module.

Eeeep!

DoC Nerd Retard Nerd
 

 
View user's profileSend private messageSend e-mail Reply with quote

Post new topic   Reply to topic  
   www.clanthemes.com Forum Index » PHPBB


 
2 Replies / 1628 Views
Page 1 of 1
All times are GMT
Display posts from previous:   
 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum