17488 Posts in 4473 Topics by 1978 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 3104 Views |
-
Trouble with the Windows intaler

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?
-
Re: Trouble with the Windows intaler

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. -
Re: Trouble with the Windows intaler

11 January 2007 at 9:24am Last edited: 11 January 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!
-
Re: Trouble with the Windows intaler

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 \gshould 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.
-
Re: Trouble with the Windows intaler

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.
| 3104 Views | ||
|
Page:
1
|
Go to Top |


