Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Trouble with the Windows intaler


Reply


5 Posts   3281 Views

Avatar
Owen

Community Member, 2 Posts

10 January 2007 at 3:14pm

I downloaded and installed the windows installer. I had MySQL running and when i tried to open the "silverstrive CMS" this is what i go:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\lighttpd\htdocs\sapphire\core\model\MySQLDatabase.php on line 21

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\lighttpd\htdocs\sapphire\core\model\MySQLDatabase.php on line 22

Fatal error: DATABASE ERROR: Could connect to MySQL database in C:\lighttpd\htdocs\sapphire\core\model\Database.php on line 185

Any suggestions?

Avatar
Simon

Core Development Team, 27 Posts

10 January 2007 at 5:46pm

Seems like MySQL isn't running to happily.

Can you see if you can open and run MySQL commands from the command prompt ?

I'll try out the installer and see if I get the same problem.
Cheers.

Avatar
Owen

Community Member, 2 Posts

11 January 2007 at 9:24am

Edited: 11/01/2007 9:29am

I got some help with MySQL but now i have a different error message.

see link below...

http://www.freeimagehosting.net/image.php?7809983931.jpg

Thanks for your help so far!

Avatar
Simon

Core Development Team, 27 Posts

12 January 2007 at 4:04pm

Yeah its got something todo with the mysql service not running perhaps.

I've installed everything from scratch on a fresh install and it is working fine apart from a "dnssd.dll" not found message. I think thats unrelated and possibly the resullt of an old setup of something with phpide.

You should ensure that the MySQL process is running

If you used our installer..

Open a command prompt. go cd c:\lighthttpd\mysql\bin\

type mysql -u root

if it runs you can try some commands to make sure the schema is all loaded correctly..

show databases \g

mysql> show databases \g
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| ss_mysite |
| test |
+--------------------+
4 rows in set (0.00 sec)

use ss_mysite \g
show tables \g

should return something like

mysql> show tables
-> \g
+--------------------------+
| Tables_in_ss_mysite |
+--------------------------+
| editablecheckbox |
| editablecheckboxoption |
| editabledropdownoption |
| editableemailfield |
| editablefilefield |
| editableformfield |
| editablememberlistfield |
| editableradiooption |
| editabletextfield |
| email_bouncerecord |
| errorpage |
| errorpage_live |
| errorpage_versions |
| file |
| folder_canedit |
| folder_canuse |
| ghostpage |
| ghostpage_live |
| ghostpage_versions |
| group |
| group_members |
| member |
| member_unsubscriberecord |
| newsletter |
| newsletter_recipient |
| newslettertype |
| page |
| page_live |
| page_versions |
| pagecomment |
| redirectorpage |
| redirectorpage_live |
| redirectorpage_versions |
| sitetree |
| sitetree_imagetracking |
| sitetree_linktracking |
| sitetree_live |
| sitetree_versions |
| submittedfilefield |
| submittedform |
| submittedformfield |
| subscribeform |
| subscribeform_live |
| subscribeform_versions |
| userdefinedform |
| userdefinedform_live |
| userdefinedform_versions |
| virtualpage |
| virtualpage_live |
| virtualpage_versions |
+--------------------------+
50 rows in set (0.00 sec)

If you don't get those results then MYSQL or the schema has been setup wrong.

Something probably went wrong in the install, so you might have to try again.

Avatar
Simon

Core Development Team, 27 Posts

12 January 2007 at 4:06pm

You could also check to see if the services are running..

right click my computer, click services, look for silverstripehttp and silverstripemysql

Just another thought.