Anyone getting SQL errors please read this!!!!!

[imported_Robert]

OK

This is just a theory so no promises that it will change anything.

What I would like people to do is log into their Cpanle and then go to MySQL and then down the bottom there is a little link that says "phpMyAdmin" click that.

Once you are there look on the right hand side under local host and find what Server version you are running.

I'm running Server version: 4.1.21-standard and have not had any problems but if yours is a lower version that might be the problem. I have tried it on Server version: 4.0.27-standard and had a heap of errors.

If this is the problem then 5 gold starts for charlie who was the one that thought of it.

[Carm]

Hi Robert,

I got this from my web host, passed it onto Marc, looks like Charlie is right as my web host version of MySQL is 4.0.27

--------------------------
Open the SQL script file that the installation uses and
remove this at every instance in the file.

DEFAULT CHARSET=latin1

When you reload the install without that text it should load
into the database fine.
---------------------------


I noticed in the main forum, Marc is working on it.

Thanks

Cheers
Carmel

[Marc]

I'll have to see what the difference will be with having that and not having that added in.

Talking to the programmer tonight.

Thanks
Marc

[PamL]

Open the SQL script file that the installation uses and
remove this at every instance in the file.

DEFAULT CHARSET=latin1

When you reload the install without that text it should load
into the database fine.
---------------------------

Carmel,
Please advise did removing "DEFAULT CHARSET=latin1" solve the problem?
Thank you.

Marc,

Thank you so much for helping. Just to update and get help :

I have checked and MySql Server Version is 4.1.21-standard, so that's not the problem.

So I re-installed my blog and the error, "DEFAULT CHARSET=latin1" had disappeared leaving the following now:


Error at the line 28: ) ENGINE=MyISAM AUTO_INCREMENT=2 ;

Query: CREATE TABLE `wp_categories` (
`cat_ID` bigint(20) NOT NULL auto_increment,
`cat_name` varchar(55) NOT NULL default '',
`category_nicename` varchar(200) NOT NULL default '',
`category_description` longtext NOT NULL,
`category_parent` bigint(20) NOT NULL default '0',
`category_count` bigint(20) NOT NULL default '0',
PRIMARY KEY (`cat_ID`),
KEY `category_nicename` (`category_nicename`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;
MySQL: Table 'wp_categories' already exists

I sent above to Hostgator and they replied:
The error states : MySQL: Table 'wp_categories' already exists
What are you trying to create the table name again ?

My question is, can I just ignore the above and move on or wait for this to be resolved?

Thank you.
Pam

[Carm]

Hi Pam,

Don't know if you have this fixed yet but in the phpMyAdmin it's not the

phpMyAdmin
MySQL client version: 4.1.10

It's the

localhost

* Server version: 4.0.27-standard

the above is what I have with my web host and

Whatever Marc did last night has fixed it as far as mine is concerned so I hope it has for you too.

I found as long as that error (CHARSET thing) came up I couldn't go any further.

Cheers
Carmel

[PamL]

Hi Carmel,
Appreciate you taking time to reply with details.
Will check with Marc.
Thank you.
Pam

[unagicrazed]

hey Pam

You need to delete that database and recreate it again and in order to use the installer.

That error occurs because the installer does not drop all the tables in the existing database. So it tried to create a table with the same name and that caused your error above. So best is to drop this database you are using and Add it again.

Otherwise just create another database to use.

cheers
Lesley

[PamL]

Lesley,
Following what you said, I have finally got my blog installed without a glitch. What a challenge! :wink:
Thank you so much and its so kind of you to have taken time and given such crystal clear explanations and most importantly provided the "solution".
Appreciate and thank you once again.

Not forgetting Charlie, Robert, Carmel and most of all Marc for being so patient and others who have taken time to help - a BIG thank you to all :wink:

Pam

[Marc]

Awesome,

Another members gets the installer working

See, now this is only the begining of the challenge.

But this is what it is all about, doing things you may have not done before, and actually doing what it takes to make it happen

Carm great to see the fix worked, it was just an issue since I created the master install on a 4.1 mysql database, those using 4.0 werent being accepted okay.

But all sorted now

You guys seriously rock.

Talk Soon
Marc