Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Trouble with the Windows intaler

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

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

Page: 1
Go to End
Author Topic: 3228 Views
  • Owen
    Avatar
    Community Member
    2 Posts

    Trouble with the Windows intaler Link to this post

    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?

  • Simon
    Avatar
    Core Development Team
    27 Posts

    Re: Trouble with the Windows intaler Link to this post

    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.

  • Owen
    Avatar
    Community Member
    2 Posts

    Re: Trouble with the Windows intaler Link to this post

    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!

  • Simon
    Avatar
    Core Development Team
    27 Posts

    Re: Trouble with the Windows intaler Link to this post

    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.

  • Simon
    Avatar
    Core Development Team
    27 Posts

    Re: Trouble with the Windows intaler Link to this post

    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.

    3228 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.