Frog CMS

From the data supplied, it looks as though Frog should run without difficulty.

Some questions, though:

• are you sure you gave the install screen the correct mySQL username/password?
• did you FTP-upload Frog as “uncompressed”? or upload an archive to the remote host, and unzip/expand/etc. remotely? (Sometimes files can get corrupted in transmission.)
• who is your host? it seems one or two have cropped up as having special, ahhh, challenges…
• can you check any log-files to see what error messages might be thrown?

There’s a start, anyway. I know you’ve had Frog running successfully locally, so you know it can be done! :)

This seems to be a fairly common occurrence. “Install successful, but no tables in database”, that is. Perhaps the installation routine could use some fixes? Maybe we need to include some troubleshooting tips in the documentation for this specific problem?

I think the only permissions that need editing were for the public folder. I haven’t installed recently, so I’m not 100% on that.

I also debugged one persons failed installation over the phone today. Frog says installation was successfull but no tables got created on database. This instance was without PDO. Config.pgp got generated correctly. Frog was installed in subdirectory.

Just got mail back about the issue. He was debugging it a bit by adding call to mysql_error() into exec() function in DoMysql.php driver. Then ran installation again and got this:

You have an error in your SQL syntax. 
Check the manual that corresponds to your MySQL server version 
for the right syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' 
at line 13

MySQL is 4.0.16.

Updated the issuetracker with this info.

kristjan, you don’t have to go to /install… just go to the frontpage of your site and Frog decides installation is necessary based on an empty config.php (i.e. if config.php is 0 bytes, it redirects to the install sequence)

Humor me.. re-download Frog, remove all the old files from Frog, upload the new download, go to the frontpage.

… BUT i still don’t get message to change config.php and /public CHMOD.

? But you should just have to fill in those fields, click “Install now”, and you should be done. You can chmod /public to 777 for installation, but unless there is a strange PDO problem (see above in thread) you should be good to go. (???)

(I’m obviously puzzled!)

@kristjan007 – if you search the forums for “SQLSTATE”, you’ll get a small handful of threads dealing with this error. Have a look through them, but perhaps the most helpful is this one — but do check the others, just in case!

It seems to be a problem either with the path to mySQL, or the version of mySQL itself. You should double check settings with your host, too.

… mysql 5.0.xx and 4.1.xx

How do you ensure that you’re on the v. 5.0.x option?

Martijn i will read this thread
EDIT: tried 127.0.0.1 but still get error:

SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ’127.0.0.1’ (111)

Instead of localhost i use mysqlhost5 because
This is data from server provider:

MySQL

Server / Host:

mysqlhost5 (MySQL 5.0)

Andmebaas / Database:

la01_9333110

Kasutajatunnus / User Name:

la01_9333110

Salasõna / Password:

XDg36xxx

it wierd that it doesn’t give error message for config.php and /public also :S

@kristjan007 – mysqlhost5 is not a fully qualified hostname… but when I tried entering it into the install screen you linked to, it spat out “10.1.0.226” as an IP address.

Try that with the correct database password.

If that works: complain to your host! They should give you the fully qualified hostname for the DB machine which you should use instead of the IP address. Using the hostname should not throw the sock error.

and again password …

is exactly what it should be: “password”. Try it!

(And if you still have trouble, have a browse through this thread.)