cannot install

desparado · Post by **desparado** » Sun Dec 12, 2004 3:32 pm

I have ran and reran the install 3 times and get the following every time:

Serendipity installation

Attemping to setup database...
Checking to see if the database is already in place. If you see a database query error here, ignore it... Done
Creating default database setup... Done
You have an error in your SQL syntax near '-_serendipityconfig (name,value,authorid) values ('template', 'default', '0')' at line 1 Done creating database
Attemping to write /home/virtual/site8/fst/var/www/html/blog/.htaccess file...Done

Warning: Invalid argument supplied for foreach() in /home/virtual/site8/fst/var/www/html/blog/serendipity_sidebar_items.php on line 688

Serendipity was successfully installed on your system.
Please remember your password: "a3m2i6c8o4m", your username is "blog admin".

You can find your new PHP blog right here
You have an error in your SQL syntax near '-_serendipityconfig (name,value,authorid) values ('dbType', 'mysql', '0')' at line 1You have an error in your SQL syntax near '-_serendipityconfig (name,value,authorid) values ('dbHost', 'localhost', '0')' at line 1You have an error in your SQL syntax near '-_serendipityconfig (name,value,authorid) values ('dbUser', 'rx03', '0')' at line 1You have an error in your SQL syntax near '-_serendipityconfig (name,value,authorid) values ('dbPass', 'a3m2i6c8o4m', '0')' at line 1You have an error in your SQL syntax near '-_serendipityconfig (name,value,authorid) values ('dbName', 'onlinedrugstorepres' at line 1You have an error in your SQL syntax near '-_serendipityconfig (name,value,authorid) values ('dbPrefix', 'onlinedrugstorepr' at line 1

<<<----- snip to conserve bandwidth - you get the idea --->>>
Configuration written & saved

Then when I go to the directory I get:

Query failed: You have an error in your SQL syntax near '-_serendipityentries AS e LEFT JOIN XXXXprescript' at line 20

HELP!!!

I would like to try this but I cannot get it installed.

WTF???

tadpole · Post by **tadpole** » Sun Dec 12, 2004 7:29 pm

It looks like you set your database prefix to a hyphen ("-"). Change it to serendipity_ or s9y_ or whatever, but it must be a valid table name.

tadpole · Post by **tadpole** » Sun Dec 12, 2004 7:38 pm

http://dev.mysql.com/doc/mysql/en/Legal_names.html

Pay special attention to the part about MySQL < 3.23.6...

A name may consist of alphanumeric characters from the current character set, `_', and `$'. The default character set is ISO-8859-1 (Latin1). This may be changed with the --default-character-set option to mysqld. See section 5.8.1 The Character Set Used for Data and Sorting.

desparado · Post by **desparado** » Sun Dec 12, 2004 7:40 pm

This is what the server defaults to and I have installed and use over 30 DBs the exact same way and have never had this problem before. Where would I change the 'prefix' name?

Stange out of 30+ DBs this is the first that's ever complained.

Thanks!

Guest · Post by **Guest** » Sun Dec 12, 2004 8:11 pm

The server defaults to: "user_-_" (without quotes) 'prefix' and the help file says:

Do not change the database prefix. Prefix changes will trigger a name change across all the databases of the site, as a result of which your sites will be unable to connect to its databases.

Now what???

desparado · Post by **desparado** » Sun Dec 12, 2004 8:13 pm

Last post (guest) was me (desparado) fogot to sign it.

desparado · Post by **desparado** » Mon Dec 13, 2004 3:14 pm

The server defaults to: "user_-_" (without quotes) 'prefix' and the help file says:

Do not change the database prefix. Prefix changes will trigger a name change across all the databases of the site, as a result of which your sites will be unable to connect to its databases.

According to this it will fry all the other databases.

I would really like to try this out.

Now what???

Also, why would it 'default' to something that it knows (should know) is 'illegal'.

Also, why would it permit you to create the database to begin with if it knows (should know) it is 'illegal'.

At any rate I would really like to try this out.

Now what???

.

desparado · Post by **desparado** » Tue Dec 14, 2004 10:46 pm

Help?

Post by **garvinhicking** » Wed Dec 15, 2004 5:09 pm

I, too, have never seens databases using "-" as separator instead of "_".

Please tell us what you have entered in the S9y Configuration into the "database prefix" input field, and what you entered into the "database name" input field. I suppose there's just a misinterpretation of what you entered there.

desparado · Post by **desparado** » Thu Dec 16, 2004 3:45 am

"database prefix" = user_c_-_
"database name" = serendipity

I tend to agree with you if it's not 'allowed' but this is the 'default' way the databases have always been setup and have never had a problem until now.
I have never changed the 'default' prefix because I never had a reason to even think about it until now.

Thanks

desparado · Post by **desparado** » Fri Dec 17, 2004 4:57 am

Now what?

Post by **garvinhicking** » Fri Dec 17, 2004 10:45 am

Do you have access to phpMyAdmin on your Site? If yes, please try this Query:

Code: Select all

USE serendipity;
CREATE TABLE user_c_-_entries

Are you REALLY sure that you created a database called 'serendipity'? In shared hosting envoronments usually the database is called like user_c_-_db and your tables could be called 'serendipity_entries' and so on.

Guest · Post by **Guest** » Sat Dec 18, 2004 6:53 pm

garvinhicking wrote:database is called like user_c_-_db

Now I'm confused....

Isn't *** user_c_-_db *** the EXACT same thing that I listed earlier as:
"database prefix" = user_c_-_
"database name" = serendipity

i.e. - user_c_-_ + serendipity = user_c_-_db ???

At any rate the query returns an error:
Error
SQL-query :
USE serendipity
MySQL said:
#1044 - Access denied for user: 'user@localhost' to database 'serendipity'

Thanks

desparado · Post by **desparado** » Sun Dec 19, 2004 5:10 pm

The last "guest" was me again.

I've never seen an installation that took a week to install in 10yrs of internet life.

I was trying to stay loyal to sourceforge but this makes it VERY difficult.

Guess wordpress is a better choice (maybe not better but CERTAINLY FASTER) since it installed FIRST TIME with NO PROBLEM without all this noise and confusion. Up and running in 5 minutes.

hmmmmmmm ..... make you wonder if its even worth it ....

tomsommer · Post by **tomsommer** » Sun Dec 19, 2004 10:51 pm

desparado wrote:The last "guest" was me again.

I've never seen an installation that took a week to install in 10yrs of internet life.

I was trying to stay loyal to sourceforge but this makes it VERY difficult.

Guess wordpress is a better choice (maybe not better but CERTAINLY FASTER) since it installed FIRST TIME with NO PROBLEM without all this noise and confusion. Up and running in 5 minutes.

hmmmmmmm ..... make you wonder if its even worth it ....

Dude, I suggest you stick with Wordpress, honestly we all have better things to do than offer support to people who has nothing nice to say.