noob cant install.sql

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

I am a noob, but have managed to get apache, ,mysql, php, myadmin all up and going.

I am trying to install raven nuke on my test machine.
I created a db named nuke and edited the config file as shown below,

Following the install instruction I get the error msg There seems to be a problem with the MySQL server Configuration Table - It's missing.

only diffrence from the instructions is that I have to click install.php from the dir list.

When I point my browser to install.sql I get a 404 page and nothing in the database.

any help in figuring out this install would be greatly appreciated.

$dbhost = 'localhost';
$dbuname = 'root';
$dbpass = 'mypass';
$dbname = 'nuke';
$prefix = 'nuke';
$user_prefix = 'nuke';
$dbtype = 'MySQL';

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

after looking through the forum for a previous version of raven, I found I should edit my php.ini file to turn on short tags..

which allows the install.sql to run, however when I click the button to install the first step core files I get error.

MySQL Error # 4 = Incorrect string value: '\xA9' for column 'title' at row 1

the database table was filled with 38 entries

again thanks in advance for any help you can give

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Welcome.

I'm confused - why not load /INSTALLATION/installSQL.php ?

.sql files are text files that aren't executed by loading them in a browser.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

I am not sure what you mean, when you ask why not load the sql file.
the instructions in the howtoinstall say that I should point my browser at installsql.php, at first this gave a 404 error, after 3 hourse of searching posts I have found I should edit php.ini to turn on short tags.

However now I still get error when trying to load step 1 "load core tables"

MySQL Error # 4 = Incorrect string value: '\xA9' for column 'title' at row 1
is displayed at bottom of screen

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

The /INSTALLATION/installSQL.php script is a PHP application that creates tables and loads default data. Your earlier post referred to install.sql, which is text file that contains SQL comments that creates tables and loads default data and must be used with an SQL utility like phpMyAdmin. You generally don't need to use both. Was there data (or tables) already in the database when you clicked load core tables? If you ran loaded the install.sql through a database utility (e.g. phpMyAdmin), that might conflict with using the installSQL.php script.

Also, you may have gotten the 404 error because the actual installation script is /INSTALLATION/installSQL.php (case-sensitive on Apache servers). Not sure why you would need to turn on short tags via php.ini (can you link to where you found this?).

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

From this post

Only registered users can see links on this board!
Get registered or login to the forums!

I had typoed the file name in my first post I have not messed with the .sql file
I am trying to operate the installsql.php script but still get the error msg at bottom of screen and cant load core files.

montego · Posted: Wed Jan 16, 2008 4:31 pm

Looks like it might be an encoding problem? Had you modified any of these files? Might also be a corrupted file. You could try downloading and extracting again.

Make sure you database encoding is not something that is incompatible with standard ISO windows file formats.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

please explain encoding or at least where to check...I have downlaoded 8 times

I went ahead and pushed the other buttons for step 1-5.

core will not load gives error
The exact error message that your MySQL server reported is:
MySQL Error # 4 = Incorrect string value: '\xA9' for column 'title' at row 1

step 2 & 3 loads.

step 4 wont load error msg is.
The exact error message that your MySQL server reported is:
MySQL Error # 4 = BLOB/TEXT column 'cdescription' can't have a default value

step 5 loads....havent tried step 6 yet.

montego · Posted: Wed Jan 16, 2008 4:46 pm

Unfortunately, I have to "run" at the moment, but take a look at the thread above this post with regards to Step 4:

Only registered users can see links on this board!
Get registered or login to the forums!

Not sure on step 1 atm... hopefully someone else can assist while I am "away"...

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

ok I read through that post but did not understand how it applied to my install or what steps I should do.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

I removed all files, re-downloaded, and installed files.
I deleted and re-created the db with a diffrent name (raven).
This time when I created the db I choose colliation utf8_unicode_ci
I edited the config.file to point to new database (this time choosing on local host user root and my root password
I re-ran the installsql.php script.
The options for step 2, & 3 still show they are installed even though its a new DB

Now when I press option 1 to insatll core files, it thinks for a minute and then refreshes the screen, but option 1 still shows not loaded.

Click option 1 again and same process repeats, some data gets entered into db 38or 39 records(forget).

option 4 still gives same error as above. (however I have no plans to use any kind of newsletter, is this needed?)
The exact error message that your MySQL server reported is:
MySQL Error # 4 = BLOB/TEXT column 'cdescription' can't have a default value

this is getting very frustrating!!!

montego · Posted: Wed Jan 16, 2008 6:05 pm

thundarfoot, it is getting frustrating because you are, for some reason, on an environment that none of us have seen just yet. (I think.)

Step 4 is going to continue to fail for the other reason that is mentioned in the other thread I posted. (You need to change the file referenced in the manner in which is was referenced.)

However, let us delete the database and re-create it, however, use a collation of:

latin1_general_ci

Let us see if that fixes the issue.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

the environment I am in is a fresh apache mysql php phpmyadming install. all with the latest packages. on a winxp machine.

Hang on ill go do the database thing again...thank you for your help.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

ok remade the db, named it Nuke, then edited config
$dbhost = 'localhost';
$dbuname = 'root';
$dbpass = 'pass';
$dbname = 'Nuke';
$prefix = 'Nuke';
$user_prefix = 'Nuke';
$dbtype = 'MySQL';

cleared I.E cache but stillw hen I load installsql.php it shows option 2,3,5 as installed.

clicked option 1 to install core, it thinks for about a min then still shows not loaded in the box.

phpmyadmin reports 39 tables were placed into Nuke DB
No error msg. but shows not loaded.

Gremmie · Posted: Wed Jan 16, 2008 6:47 pm

Can you try with Firefox?

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

still cant seem to get core to load...

but edited the newletter sql file to remove the default....it now loads bringing the table count in database to 53...

just need to figure out how to get core to load...

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

I am downloading firefox now.

Not sure if this info is important or not....
I had installed nuke 8.0 (its removed now).
I installed with out worries but when it came time to create users from inside the admin.php it would just give me a blank screen and not create the user....

While troubleshooting that, I found raven and figured I should start with a more secure package anyway (and hoped that it would fix the blank screen on user create issue). not sure if that issue and this could be related...probably not.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

Firefox shows not loaded in each of the options.

Option 1 core files, does the same thing it thinks, green bar moves as if its working then it refreshes screen and still shows not loaded.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

Ok in an effort to troubshoot this is what I have come up with.

I went into phpmyadmin and took a look at my Nuke db right after trying to load core files I have 39 tables loaded into database. the last one which is nuke_cities

I then opend the .sql file with wordpad to take a look, apparently there are a LOT of cities trying to load (what are they all used for anyway?).

The las entry in nuke_cities is
INSERT INTO $prefix.`_cities` VALUES (2040, 2, 'Deuba', 'fj', 'Fiji');

There is no information loaded after this, but looking at the .sql in wordpad it looks like a lot was left out

could it be timing out?

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

I tried opening the .sql file, copying all text.
then in php my admin inside the nuke db I tried to run SQL pasted all the text in and hit go, I got a check box asking if I realy wanted to drop table, I clicked ok

I got an error msg saying
SQL query:

CREATE TABLE IF NOT EXISTS $prefix.`_authors` (

`aid` varchar( 25 ) NOT NULL default '',
`name` varchar( 50 ) default NULL ,
`url` varchar( 255 ) NOT NULL default '',
`email` varchar( 255 ) NOT NULL default '',
`pwd` varchar( 40 ) default NULL ,
`counter` int( 11 ) NOT NULL default '0',
`radminsuper` tinyint( 1 ) NOT NULL default '1',
`admlanguage` varchar( 30 ) NOT NULL default '',
PRIMARY KEY ( `aid` )
) TYPE = MYISAM ;

MySQL said:

#1049 - Unknown database '$prefix'

Gremmie · Posted: Wed Jan 16, 2008 9:49 pm

You aren't supposed to do that. If you must, you'll have to replace all occurrences of $prefix in that file with your $prefix value (by default this is "nuke"). That's what the install script does for you behind your back.

Gremmie · Posted: Wed Jan 16, 2008 9:53 pm

thundarfoot wrote:

Ok in an effort to troubshoot this is what I have come up with.

I went into phpmyadmin and took a look at my Nuke db right after trying to load core files I have 39 tables loaded into database. the last one which is nuke_cities

There are a lot more tables than 39, so perhaps this is a clue. Maybe it is timing out for some reason.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

yeah I kinda figured I wasent supposed to run that as a sql, but wanted to "see what happens if"...

It looks as if everytime I run the script it fails at a diffrent point while loading the cites. litterly I can run it back to back and everytime it will fill in a diffrent ammount of the cities before it quits.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

How was MySQL, Apache and PHP installed on your machine? Many of us have had success with Xampp, which includes all that and is very easy to install everything.

However, if some of the tables are installed, but not all, I would first shut down everything else except the browser, including all non-essential applications running - firewall, antivirus, instant messager, etc. to leave MySQL as much free memory as possible.

Then start fresh with an empty database, and if the same problem occurs, I'd look into configuration options for MySQL (it can't handle the load, which many of have had no other problems with on Xampp-installed XP machines).

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

ok so since it kept failing at diffrent points I did the following....

I opened the sql file in word.
I opend the db in php my admin.
I ran the install scrip, looking in myadmin at cities and made note of the last record number.
In wordpad I deleted everything up to and including the last record entered. saved

re-ran install script
this time all the previous info plus some new was there....I then went back to word and deleted the now uploaded lines.
step by step I did this until all cites records were uploaded! yeah!!!

however the script fails at this line, and I am not sure how to make a primary id on already filled table

the script just will not pass this line
ALTER TABLE $prefix.`_cities` ADD PRIMARY KEY (id);

I deleted that line and the script finished without errors and instalsql.php reports loaded files! however I think that table needs a primary id?