Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
siliconeclone
New Member
New Member



Joined: Aug 21, 2006
Posts: 10

PostPosted: Mon Aug 21, 2006 4:27 pm Reply with quote

Ok so I have decided to give this Raven thang a try. Mainly I liked that it had Sentinel pre-installed.

Fresh Install, everything is running fine. A user creates an account, gets the email, clicks the link, and is taking to the page saying activation is complete, click this link to log in.

User attempts to log in with the Username and password... but it says the user does not exist...

Sure enough i check the database.. and it goes from temp_users to... POOF no where..

I searched around a bit here but I must be missing an explanation.

I am using mySQL 5.x(latest) and latest PHP5 distro. My other Nuke accounts are working properly. 7.8 with Sent. This seems to be the only problem I am having with the whole install.

EDIT:: Also when I try to manual add them through administration I get a blank page after clicking submit.

Once again this is a completely fresh un-modded install of the latest package here.
 
View user's profile Send private message
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088

PostPosted: Mon Aug 21, 2006 7:34 pm Reply with quote

I have not tested it against MySQL 5.x. 5.x has changes in how Joins have to be written. My guess would be that is where the problem is. In config.php, set display_errors=true; and see if that displays anything on the screen or in your server error log.
 
View user's profile Send private message
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Mon Aug 21, 2006 9:42 pm Reply with quote

siliconeclone, humor me just a minute. Would you please look at your nuke_users table using phpMyAdmin and see if that user was in there twice? If so, remove the later entry.

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
siliconeclone







PostPosted: Tue Aug 22, 2006 7:09 am Reply with quote

Nope there is only the Anon user in the nuke_user table. I have tested a couple times using a test account. When signing up the user does indeed go to the temp_user table. After e-mail activation tho... it just vanishes. I suppose I didn't need to upgrade to mySQL5 as 4 would suit my needs. But is there really that much of a difference between 7.6 and 7.8 that one would work in 5 and one wouldn't?

Hmm and no errors are displayed by normail e-mail activation, it just says no user found. Manual adding just comes up with a blank screen, also with no errors.


Last edited by siliconeclone on Tue Aug 22, 2006 8:43 am; edited 3 times in total 
montego







PostPosted: Tue Aug 22, 2006 7:16 am Reply with quote

I will have to default to Raven on that one then... thought, just maybe, it was an issue that I had seen before. Thanks for looking though!
 
siliconeclone







PostPosted: Tue Aug 22, 2006 7:30 am Reply with quote

I went with just the patched version of 7.6 and still get the same error. So it deffinently looks like a mysql problem most likely. Rather than downgrading my server at this point I think I am just going to go with 7.8 and work on patching that.

Thanks for taking a look tho

EDIT:: Aye it is definently MYSQL error as I notice that when I sourced in the 7.6 sql file I recieved some errors, while I did not recieve any errors sourcing in 7.8. I will need to take a look maybe it is a simple enough fix in the SQL file who knows.


Last edited by siliconeclone on Tue Aug 22, 2006 8:43 am; edited 1 time in total 
siliconeclone







PostPosted: Tue Aug 22, 2006 8:06 am Reply with quote

Ok oddly enough, Nuke instances on my server that existed before upgrading to mySQL5 had no problem creating new users. A new install of 7.8 though I had no SQL errors like the 7.6 database, still had the same problems.

Even though an already installed version of 7.8 worked fine. Odd as heck.

So seeing as it takes a grand total time of my last post and this post to uninstall mySQL5 and put mySQL4 on it, I went ahead and downgraded. Low and behold Raven 7.6 works now...

Thanks all, you hit the nail on the head with mySQL5 !
 
Raven







PostPosted: Tue Aug 22, 2006 10:55 am Reply with quote

Mysql 5 JOIN syntax change
Many older applications have been failing due to non standard queries which produce errors about columns not existing. In most instances, merely changing the order of tables is enough to fix a statement.

Example:

SELECT f.* from forums f ,categories c LEFT JOIN moderator m
ON (f.id=m.forum_id) WHERE f.category=c.id


The above produces an error about column f.id not existing, when we know it does.
By merely switching the order of the table references:
categories c and forums f
we fix the problem.

SELECT f.* from categories c,forums f LEFT JOIN moderator m
ON (f.id=m.forum_id) WHERE f.category=c.id


Please refer to the following link for more info.

[ Only registered users can see links on this board! Get registered or login! ]

See particularly "Join Processing Changes in MySQL 5.0.12
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

View next topic
View previous topic
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 can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©