Having Trouble on the install page
I edited the file <install dir>/concrete/config/db.xml
I commented the NOTNULL requirements for PkgId and jDateLastRun
I also had to default the jLastStatusText to an empty string.
I drop the db and created it again, reset the config and files dirs to their original state and the installation finally worked.
Guess that either the models/job.php install method needs to be edited or the db.xml file updated to get a clean install script
finding the <table name="Jobs"> portion of the XML, and replace it with this:
<table name="Jobs"> <field name="jID" type="I" size="10"> <KEY/> <AUTOINCREMENT/> <UNSIGNED/> </field> <field name="jName" type="C" size="100"> <NOTNULL/> </field> <field name="jDescription" type="C" size="255"> <NOTNULL/> </field> <field name="jDateInstalled" type="T"></field> <field name="jDateLastRun" type="T"></field> <field name="pkgID" type="I" size="10">
(You'll want to view the entire code block above and paste it out.)
For databases that are more strict that may work better.
My hosting package is windows with PHP5, MySQL5 Database, and the mysql server is not localhost.
Any help in getting past this stage would be appreciated.
Notice: Undefined variable: dsn in ........ concrete\libraries\loader.php on line 121
I checked the files and noticed that $dns seems to be defined in ADOdb.php, but this file is not refered by any other file. Does anyone was able to solve this issue?
I ran into this problem after a failed installation attempt (I caused the failure - no bugs here :p). Anyway, during installation, the sites.php file is created - if you try to install again, it checks to see if that file is there. If it is, then it assumes you've already installed. BUT, if it didn't properly initialize the database info the first time through, it will fail with this error.
So, the solution that worked for me was to delete config/sites.php.