problem to go through "determine type of install"

OT · New Member Joined: Apr 30, 2004 Posts: 4

env: phpnuke 7.2+mysql

status: "Great! I was able to connect to the database"

problem: pressed botton "Determine Type of Install" without changing "kissq_portfolio" and got this:

"Welcome to the KISSQ MySQL Table Installer!
Unable to Select the database. Please check your information on the previous page.

You have an error in your SQL syntax near '-_db like 'kissq_portfolio'' at line 1 "

BTW, my datebase's name is not nuke. prefix=nuke

thx a lot!

Raven · Posted: Fri Apr 30, 2004 6:25 am

I need to know the name of your database to try to see if there is a problem. This has been installed on thousands of sites without any issues so either there is a problem with your setup or something really wierd is happening Smile

. You can PM me the name if you want.

OT · New Member Joined: Apr 30, 2004 Posts: 4

name of database: invester178_com_-_db

Raven · Posted: Fri Apr 30, 2004 7:42 am

Well guess what? It appears the -db gives MySQL a migraine when issuing the Show tables command and probably all server commands. Try surrounding your database name with backward tick marks `DB_NAME`. If that doesn't work then modify the kissq-sql.php file. On or about line 63 modify this code

Code:

elseif ($action=="Determine Type of Install") {
$query = "show tables from $database like '$kissqTable'";

to

Code:

elseif ($action=="Determine Type of Install") {
$query = "show tables from `$database` like '$kissqTable'";

OT · New Member Joined: Apr 30, 2004 Posts: 4

changing name of database doesn't work.
change code is OK.

did I tell u nice job? Thx a lot.

Raven · Posted: Fri Apr 30, 2004 9:57 am

- I will update the installer. Evidently not many people name their databases with a -.

OT · New Member Joined: Apr 30, 2004 Posts: 4

the name of database is recommended by host provider. we can do nothing with it.

Raven · Posted: Fri Apr 30, 2004 10:54 am

As I said in my IM to you, I will be contacting the MySQL folks to see what's going on. Thanks.