Undefined index 'ts_created'


(vyetchnost) #1

Running 0.2.34 on PHP 5.2.6/MySQL 5.1.31/pdo_mysql/Apache 2.2.11, Solaris 10/x86

After installing and configuring, the following error is encountered on first login:

Notice: Undefined index: ts_created in /export/piwik/core/Site.php on line 48

Backtrace -->
#0 Piwik_ErrorHandler(8, Undefined index: ts_created, /export/piwik/core/Site.php, 48, Array ()) called at [/export/piwik/core/Site.php:48]
#1 Piwik_Site->getCreationDate() called at [/export/piwik/core/Controller.php:276]
#2 Piwik_Controller->redirectToIndex(CoreHome, index) called at [/export/piwik/plugins/CoreHome/Controller.php:34]
#3 Piwik_CoreHome_Controller->redirectToIndex()
#4 call_user_func_array(Array ([0] => Piwik_CoreHome_Controller Object ([] => CoreHome,[] => 2009-04-19,[] => Piwik_Date Object ([] => 1240124400)),[1] => redirectToIndex), Array ()) called at [/export/piwik/core/FrontController.php:143]
#5 Piwik_FrontController->dispatch() called at [/export/piwik/index.php:49]

This is what I have in the DB:

mysql> use piwik;
mysql> select * from site;
±-------±-----±-------------------±--------------------±---------------+
| idsite | name | main_url | ts_created | feedburnerName |
±-------±-----±-------------------±--------------------±---------------+
| 1 | test | http://example.org | 2009-04-20 09:52:59 | NULL |
±-------±-----±-------------------±--------------------±---------------+
1 row in set (0.00 sec)

mysql> create index ts_created on site(ts_created);
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> describe site;
±---------------±-----------------±-----±----±------------------±---------------+
| Field | Type | Null | Key | Default | Extra |
±---------------±-----------------±-----±----±------------------±---------------+
| idsite | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(90) | NO | | NULL | |
| main_url | varchar(255) | NO | | NULL | |
| ts_created | timestamp | NO | MUL | CURRENT_TIMESTAMP | |
| feedburnerName | varchar(100) | YES | | NULL | |
±---------------±-----------------±-----±----±------------------±---------------+
5 rows in set (0.00 sec)

mysql>

As you can see, ‘ts_created’ most certainly exists, and is most certainly an index, contrary to the error message.

These error messages seem to point to a timestamp format issue:

“0” “Piwik_Date is expecting a unix timestamp” “/export/piwik/core/Date.php” “65” “#0 /export/piwik/core/Date.php(41): Piwik_Date->__construct(NULL)\n#1 /export/piwik/core/Site.php(49): Piwik_Date::factory(NULL)\n#2 /export/piwik/core/Controller.php(276): Piwik_Site->getCreationDate()\n#3 /export/piwik/plugins/CoreHome/Controller.php(34): Piwik_Controller->redirectToIndex(‘CoreHome’, ‘index’)\n#4 [internal function]: Piwik_CoreHome_Controller->redirectToIndex()\n#5 /export/piwik/core/FrontController.php(143): call_user_func_array(Array, Array)\n#6 /export/piwik/index.php(49): Piwik_FrontController->dispatch()\n#7 {main}” “2009-04-20T11:05:59-07:00”

“0” “Date format must be: YYYY-MM-DD, or ‘today’ or ‘yesterday’ or any keyword supported by the strtotime function (see http://php.net/strtotime for more information)” “/export/piwik/core/Date.php” “39” “#0 /export/piwik/core/Site.php(49): Piwik_Date::factory(NULL)\n#1 /export/piwik/core/Controller.php(276): Piwik_Site->getCreationDate()\n#2 /export/piwik/plugins/CoreHome/Controller.php(34): Piwik_Controller->redirectToIndex(‘CoreHome’, ‘index’)\n#3 [internal function]: Piwik_CoreHome_Controller->redirectToIndex()\n#4 /export/piwik/core/FrontController.php(143): call_user_func_array(Array, Array)\n#5 /export/piwik/index.php(49): Piwik_FrontController->dispatch()\n#6 {main}” “2009-04-20T11:07:15-07:00”

Please help.


(Matthieu Aubry) #2

please create a ticket with as much information as you can provide thanks