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
fedrosilba
New Member
New Member


Joined: Jun 09, 2006
Posts: 6

PostPosted: Fri Jun 09, 2006 10:21 am Reply with quote

Hi to you all;
sorry to bother you with problably such an easy question, but i'm really in the beguinning of php.
My problrm is that when i try to the core install the tables it gives me an error saying:
"ERROR! The exact error message that your MySQL server reported is You have an error in your SQL syntax near '; ' at line 1."
Thank you all
oneLove&unity
 
View user's profile Send private message
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Fri Jun 09, 2006 10:40 am Reply with quote

Could you provide us with some more details:

1. Is this an empty site that you are installing to (no previous Nuke).
2. You downloaded RN 2.02 from this site recently? Just confirm this.
3. Apparently you edited the config.php according to the instructions or you would have gotten either an "I can't find config.php" or an "I can't connect to the database using your config.php" type message. But could you confirm that you get a message when running installSQL.php that the config.php was found?

If you have access to phpmyadmin maybe you could also look at the database where you are trying to load the core tables and let us know if any were created.

Hummm ... thinking as I write. The message you report is kind of strange. Can you look in your site at the files (directly on the server would be best if your FTP client lets you view the files, but at the very least in the directory you uploaded). Take a look at the INSTALLATION directory and then within that the SQL directory and the file rn76_core_pl32.sql. The first line in that file tries to drop the authors table if it already exists. Could you confirm that line is there (as well as that file?).
 
View user's profile Send private message Visit poster's website
fedrosilba
PostPosted: Fri Jun 09, 2006 11:09 am Reply with quote

hi fkelly;
Tx for your help.
As i told before my knolege of php is very small so i´ll try to explain it the best i can.
1. I think it´s an empty site i´m installing i never worked with nuke even though i´ve downloaded it and try to play with it (i never saved any work)
2. Does RN2.02 stand for the ravennuke? if so, yes, i´ve downloaded 3 days ago.
3. I´ve edited the config.php and in the page that we install the core tables it recognizes the database, username and password. (the database i´ve created it via phpmyadmin)
At the moment i can´t take a look at the files because they are at my schools computer)

Once again thank you for your help

oneLove&unity
 
fkelly
PostPosted: Fri Jun 09, 2006 11:23 am Reply with quote

Sorry for the unexplained acronymn. I hate those generally. Yes, RN is shorthand for RavenNuke. It sounds like you are on the right track with editing config.php so if you could just check out those other questions I raised maybe we can find a way to help. In the back of my mind I'm thinking maybe something went wrong with your FTP transfer up to the server, maybe all the sub directories didn't get copied, because having that error in line 1 is pretty suspicious (or I should say indicative). If you can look at that file I mentioned and tell us that will give us more to go on.
 
fedrosilba
PostPosted: Fri Jun 09, 2006 11:37 am Reply with quote

Ok my friend.
Unfortunally, only mondey.
Just one thing...
I haven´t still copied the files to a web server, but my computer is a server..
I´m running apache and have my files in the htdocs directory.
I think it´s the same thing as having them in a web server, right?
Thanks for your time and mondey i´ll post a message about the file in the sql directory.

oneLove&unity
 
fedrosilba
PostPosted: Mon Jun 12, 2006 3:24 am Reply with quote

hi fkelly
I´ve looking for that file that you´ve mentioned in the sql directory and it doesn´t exist.
 
fkelly
PostPosted: Mon Jun 12, 2006 8:41 am Reply with quote

Welcome back fedrosilba. It's good in a way that you couldn't find that file because it explains your difficulty. There are others who are much more expert with Apache than I am but I am assuming that you have something like this in your Apache configuration file (since you mention htdocs):

Quote:
# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
#
# DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs"
DocumentRoot "E:/webpage/mhcc_web/test/test_active_site"


The # lines indicate comments and the htdocs line is where Apache defaults to. I've changed it on my site to something else but if you are "pointing" document root at htdocs then that's where your files should be.

Using that directory you could have just taken the Ravennuke zip file that you downloaded and unzipped it there. So within that you'd have a html directory and within that an INSTALLATION directory and then within that a SQL directory and then within that the file I asked you to look for. If you unzipped the distribution somewhere else you could just copy the whole structure over to htdocs. But at any rate the installSQL.php program needs to be able to find that file I listed within a SQL directory within the INSTALLATION directory.

So let's start there and try to get those files in the right place from the distribution and see if your luck changes.
 
fedrosilba
PostPosted: Mon Jun 12, 2006 9:40 am Reply with quote

Peace friend.
That´s what i´ve done. I´ve unziped the ravennuke to my desktop and then copied it to the htdocs folder.

Now i´ve tried to copy the zip file to the htdocs and unzipe it there, so I have something like this:

htdos --> rwsRavenNuke76_v2.02.00_FULL --> html --> INSTALLATION --> sql

and there is a file named "rn76_core_pl31.sql", but the file you mentioned is "rn76_core_pl32.sql"

oneLove&unity
 
fkelly
PostPosted: Mon Jun 12, 2006 11:08 am Reply with quote

I think that what you want to download is the 2.02.02 version. Sorry but you'd be better off starting over with that because it contains a bunch of fixes from 2.02.00. I'm pretty sure Raven would have incremented the release number from pl31 to pl32 on that file and that would explain the discrepancy.

Sorry about that but you will save yourself time if you delete the download you got and go get the right one.
 
fedrosilba
PostPosted: Mon Jun 12, 2006 11:33 am Reply with quote

OK my freind
Thanks you very much for your trouble and till next i wish you peace

oneLove&unity
 
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 ©