No valid database

Si vous n'arrivez pas à configurer le composant pour votre collection...

par zoe » Ven 13 Aoû 2010 20:46

I seem to have a problem with my collector database. Instead of the collection I get this:
Code: Tout sélectionner
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c.ordering' at line 1 SQL=SELECT c.id AS cid, c.*, u.name AS creator, u2.name AS author, u.usertype, h.*, v7.value AS `field_7`, v1.value AS `field_1`, v11.value AS `field_11`, v10.value AS `field_10`, v3.value AS `field_3`, v5.value AS `field_5`, v13.value AS `field_13`, v14.value AS `field_14`, v15.value AS `field_15`, v16.value AS `field_16`, v20.value AS `field_20`, v21.value AS `field_21`, v29.value AS `field_29`, v22.value AS `field_22`, v27.value AS `field_27`, v28.value AS `field_28`, v30.value AS `field_30`, v31.value AS `field_31`, v32.value AS `field_32`, v12.value AS `field_12`, v9.value AS `field_9`, v37.value AS `field_37`, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_collector_items` AS c LEFT JOIN `jos_users` AS u ON u.id = c.created_by LEFT JOIN `jos_users` AS u2 ON u2.id = c.modified_by LEFT JOIN `jos_collector_items_history` AS h ON h.item = c.id LEFT JOIN `jos_collector_items_values` AS v7 ON v7.history = h.id AND v7.field = 7 LEFT JOIN `jos_collector_items_values` AS v1 ON v1.history = h.id AND v1.field = 1 LEFT JOIN `jos_collector_items_values` AS v11 ON v11.history = h.id AND v11.field = 11 LEFT JOIN `jos_collector_items_values` AS v10 ON v10.history = h.id AND v10.field = 10 LEFT JOIN `jos_collector_defined_content` AS d10 ON d10.id = v10.value LEFT JOIN `jos_collector_items_values` AS v3 ON v3.history = h.id AND v3.field = 3 LEFT JOIN `jos_collector_defined_content` AS d3 ON d3.id = v3.value LEFT JOIN `jos_collector_items_values` AS v5 ON v5.history = h.id AND v5.field = 5 LEFT JOIN `jos_collector_items_values` AS v13 ON v13.history = h.id AND v13.field = 13 LEFT JOIN `jos_collector_items_values` AS v14 ON v14.history = h.id AND v14.field = 14 LEFT JOIN `jos_collector_items_values` AS v15 ON v15.history = h.id AND v15.field = 15 LEFT JOIN `jos_collector_items_values` AS v16 ON v16.history = h.id AND v16.field = 16 LEFT JOIN `jos_collector_items_values` AS v20 ON v20.history = h.id AND v20.field = 20 LEFT JOIN `jos_collector_items_values` AS v21 ON v21.history = h.id AND v21.field = 21 LEFT JOIN `jos_collector_items_values` AS v29 ON v29.history = h.id AND v29.field = 29 LEFT JOIN `jos_collector_items_values` AS v22 ON v22.history = h.id AND v22.field = 22 LEFT JOIN `jos_collector_items_values` AS v27 ON v27.history = h.id AND v27.field = 27 LEFT JOIN `jos_collector_items_values` AS v28 ON v28.history = h.id AND v28.field = 28 LEFT JOIN `jos_collector_items_values` AS v30 ON v30.history = h.id AND v30.field = 30 LEFT JOIN `jos_collector_items_values` AS v31 ON v31.history = h.id AND v31.field = 31 LEFT JOIN `jos_collector_items_values` AS v32 ON v32.history = h.id AND v32.field = 32 LEFT JOIN `jos_collector_items_values` AS v12 ON v12.history = h.id AND v12.field = 12 LEFT JOIN `jos_collector_items_values` AS v9 ON v9.history = h.id AND v9.field = 9 LEFT JOIN `jos_collector_items_values` AS v37 ON v37.history = h.id AND v37.field = 37 WHERE c.collection = 1 AND h.state = 1 AND c.access <= 0 AND ( ( c.created_by = 0 ) OR ( c.state = 1 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-08-13 18:40:48' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-08-13 18:40:48' ) ) ) ORDER BY , c.ordering

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home8/ginnysi/public_html/sloaussie/libraries/joomla/database/database/mysql.php on line 344
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c.ordering LIMIT 0, 20' at line 1 SQL=SELECT c.id AS cid, c.*, u.name AS creator, u2.name AS author, u.usertype, h.*, v7.value AS `field_7`, v1.value AS `field_1`, v11.value AS `field_11`, v10.value AS `field_10`, v3.value AS `field_3`, v5.value AS `field_5`, v13.value AS `field_13`, v14.value AS `field_14`, v15.value AS `field_15`, v16.value AS `field_16`, v20.value AS `field_20`, v21.value AS `field_21`, v29.value AS `field_29`, v22.value AS `field_22`, v27.value AS `field_27`, v28.value AS `field_28`, v30.value AS `field_30`, v31.value AS `field_31`, v32.value AS `field_32`, v12.value AS `field_12`, v9.value AS `field_9`, v37.value AS `field_37`, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_collector_items` AS c LEFT JOIN `jos_users` AS u ON u.id = c.created_by LEFT JOIN `jos_users` AS u2 ON u2.id = c.modified_by LEFT JOIN `jos_collector_items_history` AS h ON h.item = c.id LEFT JOIN `jos_collector_items_values` AS v7 ON v7.history = h.id AND v7.field = 7 LEFT JOIN `jos_collector_items_values` AS v1 ON v1.history = h.id AND v1.field = 1 LEFT JOIN `jos_collector_items_values` AS v11 ON v11.history = h.id AND v11.field = 11 LEFT JOIN `jos_collector_items_values` AS v10 ON v10.history = h.id AND v10.field = 10 LEFT JOIN `jos_collector_defined_content` AS d10 ON d10.id = v10.value LEFT JOIN `jos_collector_items_values` AS v3 ON v3.history = h.id AND v3.field = 3 LEFT JOIN `jos_collector_defined_content` AS d3 ON d3.id = v3.value LEFT JOIN `jos_collector_items_values` AS v5 ON v5.history = h.id AND v5.field = 5 LEFT JOIN `jos_collector_items_values` AS v13 ON v13.history = h.id AND v13.field = 13 LEFT JOIN `jos_collector_items_values` AS v14 ON v14.history = h.id AND v14.field = 14 LEFT JOIN `jos_collector_items_values` AS v15 ON v15.history = h.id AND v15.field = 15 LEFT JOIN `jos_collector_items_values` AS v16 ON v16.history = h.id AND v16.field = 16 LEFT JOIN `jos_collector_items_values` AS v20 ON v20.history = h.id AND v20.field = 20 LEFT JOIN `jos_collector_items_values` AS v21 ON v21.history = h.id AND v21.field = 21 LEFT JOIN `jos_collector_items_values` AS v29 ON v29.history = h.id AND v29.field = 29 LEFT JOIN `jos_collector_items_values` AS v22 ON v22.history = h.id AND v22.field = 22 LEFT JOIN `jos_collector_items_values` AS v27 ON v27.history = h.id AND v27.field = 27 LEFT JOIN `jos_collector_items_values` AS v28 ON v28.history = h.id AND v28.field = 28 LEFT JOIN `jos_collector_items_values` AS v30 ON v30.history = h.id AND v30.field = 30 LEFT JOIN `jos_collector_items_values` AS v31 ON v31.history = h.id AND v31.field = 31 LEFT JOIN `jos_collector_items_values` AS v32 ON v32.history = h.id AND v32.field = 32 LEFT JOIN `jos_collector_items_values` AS v12 ON v12.history = h.id AND v12.field = 12 LEFT JOIN `jos_collector_items_values` AS v9 ON v9.history = h.id AND v9.field = 9 LEFT JOIN `jos_collector_items_values` AS v37 ON v37.history = h.id AND v37.field = 37 WHERE c.collection = 1 AND h.state = 1 AND c.access <= 0 AND ( ( c.created_by = 0 ) OR ( c.state = 1 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-08-13 18:40:48' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-08-13 18:40:48' ) ) ) ORDER BY , c.ordering LIMIT 0, 20
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c.ordering' at line 1 SQL=SELECT c.id AS cid, c.*, u.name AS creator, u2.name AS author, u.usertype, h.*, v7.value AS `field_7`, v1.value AS `field_1`, v11.value AS `field_11`, v10.value AS `field_10`, v3.value AS `field_3`, v5.value AS `field_5`, v13.value AS `field_13`, v14.value AS `field_14`, v15.value AS `field_15`, v16.value AS `field_16`, v20.value AS `field_20`, v21.value AS `field_21`, v29.value AS `field_29`, v22.value AS `field_22`, v27.value AS `field_27`, v28.value AS `field_28`, v30.value AS `field_30`, v31.value AS `field_31`, v32.value AS `field_32`, v12.value AS `field_12`, v9.value AS `field_9`, v37.value AS `field_37`, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_collector_items` AS c LEFT JOIN `jos_users` AS u ON u.id = c.created_by LEFT JOIN `jos_users` AS u2 ON u2.id = c.modified_by LEFT JOIN `jos_collector_items_history` AS h ON h.item = c.id LEFT JOIN `jos_collector_items_values` AS v7 ON v7.history = h.id AND v7.field = 7 LEFT JOIN `jos_collector_items_values` AS v1 ON v1.history = h.id AND v1.field = 1 LEFT JOIN `jos_collector_items_values` AS v11 ON v11.history = h.id AND v11.field = 11 LEFT JOIN `jos_collector_items_values` AS v10 ON v10.history = h.id AND v10.field = 10 LEFT JOIN `jos_collector_defined_content` AS d10 ON d10.id = v10.value LEFT JOIN `jos_collector_items_values` AS v3 ON v3.history = h.id AND v3.field = 3 LEFT JOIN `jos_collector_defined_content` AS d3 ON d3.id = v3.value LEFT JOIN `jos_collector_items_values` AS v5 ON v5.history = h.id AND v5.field = 5 LEFT JOIN `jos_collector_items_values` AS v13 ON v13.history = h.id AND v13.field = 13 LEFT JOIN `jos_collector_items_values` AS v14 ON v14.history = h.id AND v14.field = 14 LEFT JOIN `jos_collector_items_values` AS v15 ON v15.history = h.id AND v15.field = 15 LEFT JOIN `jos_collector_items_values` AS v16 ON v16.history = h.id AND v16.field = 16 LEFT JOIN `jos_collector_items_values` AS v20 ON v20.history = h.id AND v20.field = 20 LEFT JOIN `jos_collector_items_values` AS v21 ON v21.history = h.id AND v21.field = 21 LEFT JOIN `jos_collector_items_values` AS v29 ON v29.history = h.id AND v29.field = 29 LEFT JOIN `jos_collector_items_values` AS v22 ON v22.history = h.id AND v22.field = 22 LEFT JOIN `jos_collector_items_values` AS v27 ON v27.history = h.id AND v27.field = 27 LEFT JOIN `jos_collector_items_values` AS v28 ON v28.history = h.id AND v28.field = 28 LEFT JOIN `jos_collector_items_values` AS v30 ON v30.history = h.id AND v30.field = 30 LEFT JOIN `jos_collector_items_values` AS v31 ON v31.history = h.id AND v31.field = 31 LEFT JOIN `jos_collector_items_values` AS v32 ON v32.history = h.id AND v32.field = 32 LEFT JOIN `jos_collector_items_values` AS v12 ON v12.history = h.id AND v12.field = 12 LEFT JOIN `jos_collector_items_values` AS v9 ON v9.history = h.id AND v9.field = 9 LEFT JOIN `jos_collector_items_values` AS v37 ON v37.history = h.id AND v37.field = 37 WHERE c.collection = 1 AND h.state = 1 AND c.access <= 0 AND ( ( c.created_by = 0 ) OR ( c.state = 1 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-08-13 18:40:48' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-08-13 18:40:48' ) ) ) ORDER BY , c.ordering

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home8/ginnysi/public_html/sloaussie/libraries/joomla/database/database/mysql.php on line 344
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' c.ordering' at line 1 SQL=SELECT c.id AS cid, c.*, u.name AS creator, u2.name AS author, u.usertype, h.*, v7.value AS `field_7`, v1.value AS `field_1`, v11.value AS `field_11`, v10.value AS `field_10`, v3.value AS `field_3`, v5.value AS `field_5`, v13.value AS `field_13`, v14.value AS `field_14`, v15.value AS `field_15`, v16.value AS `field_16`, v20.value AS `field_20`, v21.value AS `field_21`, v29.value AS `field_29`, v22.value AS `field_22`, v27.value AS `field_27`, v28.value AS `field_28`, v30.value AS `field_30`, v31.value AS `field_31`, v32.value AS `field_32`, v12.value AS `field_12`, v9.value AS `field_9`, v37.value AS `field_37`, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_collector_items` AS c LEFT JOIN `jos_users` AS u ON u.id = c.created_by LEFT JOIN `jos_users` AS u2 ON u2.id = c.modified_by LEFT JOIN `jos_collector_items_history` AS h ON h.item = c.id LEFT JOIN `jos_collector_items_values` AS v7 ON v7.history = h.id AND v7.field = 7 LEFT JOIN `jos_collector_items_values` AS v1 ON v1.history = h.id AND v1.field = 1 LEFT JOIN `jos_collector_items_values` AS v11 ON v11.history = h.id AND v11.field = 11 LEFT JOIN `jos_collector_items_values` AS v10 ON v10.history = h.id AND v10.field = 10 LEFT JOIN `jos_collector_defined_content` AS d10 ON d10.id = v10.value LEFT JOIN `jos_collector_items_values` AS v3 ON v3.history = h.id AND v3.field = 3 LEFT JOIN `jos_collector_defined_content` AS d3 ON d3.id = v3.value LEFT JOIN `jos_collector_items_values` AS v5 ON v5.history = h.id AND v5.field = 5 LEFT JOIN `jos_collector_items_values` AS v13 ON v13.history = h.id AND v13.field = 13 LEFT JOIN `jos_collector_items_values` AS v14 ON v14.history = h.id AND v14.field = 14 LEFT JOIN `jos_collector_items_values` AS v15 ON v15.history = h.id AND v15.field = 15 LEFT JOIN `jos_collector_items_values` AS v16 ON v16.history = h.id AND v16.field = 16 LEFT JOIN `jos_collector_items_values` AS v20 ON v20.history = h.id AND v20.field = 20 LEFT JOIN `jos_collector_items_values` AS v21 ON v21.history = h.id AND v21.field = 21 LEFT JOIN `jos_collector_items_values` AS v29 ON v29.history = h.id AND v29.field = 29 LEFT JOIN `jos_collector_items_values` AS v22 ON v22.history = h.id AND v22.field = 22 LEFT JOIN `jos_collector_items_values` AS v27 ON v27.history = h.id AND v27.field = 27 LEFT JOIN `jos_collector_items_values` AS v28 ON v28.history = h.id AND v28.field = 28 LEFT JOIN `jos_collector_items_values` AS v30 ON v30.history = h.id AND v30.field = 30 LEFT JOIN `jos_collector_items_values` AS v31 ON v31.history = h.id AND v31.field = 31 LEFT JOIN `jos_collector_items_values` AS v32 ON v32.history = h.id AND v32.field = 32 LEFT JOIN `jos_collector_items_values` AS v12 ON v12.history = h.id AND v12.field = 12 LEFT JOIN `jos_collector_items_values` AS v9 ON v9.history = h.id AND v9.field = 9 LEFT JOIN `jos_collector_items_values` AS v37 ON v37.history = h.id AND v37.field = 37 WHERE c.collection = 1 AND h.state = 1 AND c.access <= 0 AND ( ( c.created_by = 0 ) OR ( c.state = 1 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2010-08-13 18:40:48' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2010-08-13 18:40:48' ) ) ) ORDER BY , c.ordering

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home8/ginnysi/public_html/sloaussie/libraries/joomla/database/database/mysql.php on line 344
Predstavniki


It is also seen here: http://slo-aussie.com/sl/predstavniki

What can I do to fix this?

Thank you for your help
zoe
 
Messages: 5
Inscription: Sam 12 Juin 2010 16:34

par steevo » Lun 16 Aoû 2010 23:41

Hi,

Erase your link menu and recreate it.
I don't know why but some link information are lost in upgrade.
Avatar de l’utilisateur
steevo
Administrateur du site
 
Messages: 330
Inscription: Jeu 17 Déc 2009 22:59

par zoe » Mar 17 Aoû 2010 16:35

Thank you, it works now :)
zoe
 
Messages: 5
Inscription: Sam 12 Juin 2010 16:34


Retourner vers Problème de paramétrage

cron

Qui est en ligne

Utilisateurs parcourant ce forum: Aucun utilisateur enregistré et 1 invité