Having Trouble on the install page

Permalink
Notice: Undefined variable: dsn in ...\concrete\concrete\libraries\loader.php on line 121
View Replies:
dpg replied on at Permalink Reply
From the install page I get mysql error: [1364: Field 'jDateLastRun' doesn't have a default value] in EXECUTE("INSERT INTO Jobs (jName, jDescription, jDateInstalled, jNotUninstallable, jHandle) VALUES('Index Search Engine','Index the site to allow searching to work quickly and accurately.','2008-10-30 23:56:42 PM',1,'index_search')")
andrew replied on at Permalink Reply
andrew
What is your MySQL version? Could you try enabling less strict date checking described here? http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html I'm wondering if c5 needs to be a little less lax in some of its queries but we've never noticed it before.
dpg replied on at Permalink Reply
You guys are on it. I've been looking into this some more, It's more than likely on my end. The Database was created with 59 tables, site.php is blank... 'jDateLastRun' does not allow nulls, has no default and is a datetime. My datetime format is set to %Y-%m-%d %H:%i:%s. I'll try again later. Thanks
pavkamlc replied on at Permalink Reply
Page http://www.concrete5.org/index.php?cID=229 write me this error and there is not button for new question. Notice: Undefined variable: dsn in ...\concrete\concrete\libraries\loader.php on line 121
bvidis replied on at Permalink Reply
bvidis
Hi, I ran into the very same problem.

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
andrew replied on at Permalink Reply
andrew
If you're having troubles getting install to work and it's an error in your Jobs table, try opening

concrete/config/db.xml

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">
Viewing 15 lines of 36 lines. View entire code block.


(You'll want to view the entire code block above and paste it out.)

For databases that are more strict that may work better.
pavkamlc replied on at Permalink Reply
I've tried install concrete on Ubuntu 8.10. I've created concrete mysql database and user, but install page writes: Unable to connect to a database using those credentials.
andrew replied on at Permalink Reply
andrew
are you specifying "localhost" as your db server?
dpg replied on at Permalink Reply
Apache 2.2 PHP Version 5.2.6 MySQL 5.0 PHPMyAdmin 3.0.1
ligria replied on at Permalink Reply
I'm having the same problem. Although not on Ubuntu Intrepid but on my host provider. I have 'localhost' defined as database server but no luck anyway :(
therealanda replied on at Permalink Reply
does your server support php5! and mysql databases? quess i had the same problem - with my php4 server greets, anda
ligria replied on at Permalink Reply
yeah. php 5.2.6 and mysql 4.1.22-standard-log. i think I got everything right. but might be overlooking something :-(
M81162 replied on at Permalink Reply
I have just tried to install C5 and get the same error as in this topic.

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.
cajo replied on at Permalink Reply
I'm having the same problem when I tried to install:

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?
Kryten replied on at Permalink Reply
I know this is an old thread, but here's one possible solution.

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.
SeregaGl replied on at Permalink Reply
I had the same problem. Just reinstall php and mysql to newer versions.