Tickets :: [#7948] sql query error

6.0.0-beta1

7/6/25

Summary	sql query error
Queue	Kronolith
Queue Version	Git master
Type	Bug
State	Resolved
Priority	2. Medium
Owners	mrubinsk (at) horde (dot) org
Requester	horde (at) smartsector (dot) hu
Created	02/04/2009 (5996 days ago)
Due
Updated	02/09/2009 (5991 days ago)
Assigned	02/04/2009 (5996 days ago)
Resolved	02/09/2009 (5991 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

02/09/2009 10:27:00 PM	Michael Rubinsky	Assigned to Michael Rubinsky State ⇒ Resolved

02/09/2009 10:01:09 PM	horde (at) smartsector (dot) hu	Comment #9	Reply to this comment
You need to create the database tables for the content package. These are the rampage_* tables that are defined in the content/data/rampage_*.xml files. It's ok, after creating the new tables! Thx!

02/05/2009 05:52:22 PM	Michael Rubinsky	Comment #8	Reply to this comment
You need to create the database tables for the content package. These are the rampage_* tables that are defined in the content/data/rampage_*.xml files.

02/05/2009 12:27:25 PM	horde (at) smartsector (dot) hu	Comment #7	Reply to this comment
Did you create the content tables? Clearly I must missed something, but what are the content tables?

02/04/2009 11:22:38 PM	Michael Rubinsky	Comment #6	Reply to this comment
Did you create the content tables?

02/04/2009 10:56:57 PM	horde (at) smartsector (dot) hu	Comment #5	Reply to this comment
Latest Horde_Db did not fix the problem...

02/04/2009 10:55:03 PM	horde (at) smartsector (dot) hu	Comment #4	Reply to this comment
The config is: $conf['sql']['username'] = '******'; $conf['sql']['password'] = '*****'; $conf['sql']['protocol'] = 'unix'; $conf['sql']['database'] = 'horde'; $conf['sql']['charset'] = 'UTF-8'; $conf['sql']['splitread'] = false; $conf['sql']['phptype'] = 'mysqli'; If I change mysqli to mysql the error message is different: Fatal error: Uncaught exception 'Horde_Db_Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.rampage_types' doesn't exist' in /usr/share/php/Horde/Db/Adapter/Abstract.php:423 Stack trace: #0 /usr/share/php/Horde/Db/Adapter/Pdo/Abstract.php(139): Horde_Db_Adapter_Abstract->execute('SELECT type_id,...', NULL, NULL) #1 /usr/share/horde/content/lib/Types/Manager.php(75): Horde_Db_Adapter_Pdo_Abstract->selectAssoc('SELECT type_id,...') #2 /usr/share/horde/kronolith/lib/Tagger.php(57): Content_Types_Manager->ensureTypes(Array) #3 /usr/share/horde/kronolith/templates/panel.inc(28): Kronolith_Tagger->__construct() #4 /usr/share/horde/kronolith/month.php(39): require('/usr/share/hord...') #5 /usr/share/horde/kronolith/index.php(23): include('/usr/share/hord...') #6 {main} thrown in /usr/share/php/Horde/Db/Adapter/Abstract.php on line 423

02/04/2009 09:42:57 PM	Michael Rubinsky	Comment #3	Reply to this comment
...and can you see if the latest commit to Horde_Db fixes this for you? http://lists.horde.org/archives/commits/2009-February/000442.html

02/04/2009 09:24:29 PM	Chuck Hagenbuch	Comment #2 State ⇒ Feedback	Reply to this comment
What does your $conf['sql'] array look like (without the password, please)?

02/04/2009 08:36:40 PM	horde (at) smartsector (dot) hu	Comment #1 Milestone ⇒ State ⇒ Unconfirmed Patch ⇒ No Queue ⇒ Kronolith Summary ⇒ sql query error Type ⇒ Bug Priority ⇒ 2. Medium	Reply to this comment
This error is displayed below the calendar view of the user: Fatal error: Uncaught exception 'Horde_Db_Exception' with message 'QUERY FAILED: No database selected SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN ('calendar','event')' in /usr/share/php/Horde/Db/Adapter/Mysqli.php:299 Stack trace: #0 /usr/share/php/Horde/Db/Adapter/Mysqli.php(217): Horde_Db_Adapter_Mysqli->execute('SELECT type_id,...', NULL, NULL) #1 /usr/share/php/Horde/Db/Adapter/Abstract.php(391): Horde_Db_Adapter_Mysqli->selectAll('SELECT type_id,...', NULL, NULL) #2 /usr/share/horde/content/lib/Types/Manager.php(75): Horde_Db_Adapter_Abstract->selectAssoc('SELECT type_id,...') #3 /usr/share/horde/kronolith/lib/Tagger.php(57): Content_Types_Manager->ensureTypes(Array) #4 /usr/share/horde/kronolith/templates/panel.inc(28): Kronolith_Tagger->__construct() #5 /usr/share/horde/kronolith/month.php(39): require('/usr/share/hord...') #6 /usr/share/horde/kronolith/index.php(23): include('/usr/share/hord...') #7 {main} thrown in /usr/share/php/Horde/Db/Adapter/Mysqli.php on line 299