Posted by saml on August 26, 2006 at 2:41am
Jump to:
| Project: | Flexinode |
| Version: | 4.7.x-1.x-dev |
| Component: | flexinode.module (core) |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
I just upgraded my 4.6 site to 4.7.3.
The flexinode module was upgraded from v 1.46.2.4 2005/11/29 (4.6 version), to v 1.77.2.1 2006/08/22 (4.7 version)
After running update.php (the flexinode tables were updated) I get the following error when looking at a flexinode node:
* user warning: 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 ' , flexinode_12.textual_data AS flexinode_12, flexinode_12.numeric_data AS flexi' at line 1 query: SELECT flexinode_17.textual_data AS flexinode_17, flexinode_7.numeric_data AS flexinode_7, flexinode_10.textual_data AS flexinode_10, flexinode_15.textual_data AS flexinode_15, flexinode_14.textual_data AS flexinode_14, flexinode_8.serialized_data AS flexinode_8, , , flexinode_12.textual_data AS flexinode_12, flexinode_12.numeric_data AS flexinode_12_format FROM credo_node n LEFT JOIN credo_flexinode_data flexinode_17 ON n.nid = flexinode_17.nid AND flexinode_17.field_id = 17 LEFT JOIN credo_flexinode_data flexinode_7 ON n.nid = flexinode_7.nid AND flexinode_7.field_id = 7 LEFT JOIN credo_flexinode_data flexinode_10 ON n.nid = flexinode_10.nid AND flexinode_10.field_id = 10 LEFT JOIN credo_flexinode_data flexinode_15 ON n.nid = flexinode_15.nid AND flexinode_15.field_id = 15 LEFT JOIN credo_flexinode_data flexinode_14 ON n.nid = flexinode_14.nid AND flexinode_14.field_id = 14 LEFT JOIN credo_flexinode_data flexinode_8 ON n.nid = flexinode_8.nid AND flexinode_8.field_id = 8 LEFT JOIN credo_flexinode_data flexinode_9 ON n.nid = flexinode_9.nid AND flexinode_9.field_id = 9 LEFT JOIN credo_flexinode_data flexinode_16 ON n.nid = flexinode_16.nid AND flexinode_16.field_id = 16 LEFT JOIN credo_flexinode_data flexinode_12 ON n.nid = flexinode_12.nid AND flexinode_12.field_id = 12 WHERE n.nid = 132 in E:\xampplite\htdocs\upgrade47\includes\database.mysql.inc on line 120. * user warning: 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 ' , flexinode_12.textual_data AS flexinode_12, flexinode_12.numeric_data AS flexi' at line 1 query: SELECT flexinode_17.textual_data AS flexinode_17, flexinode_7.numeric_data AS flexinode_7, flexinode_10.textual_data AS flexinode_10, flexinode_15.textual_data AS flexinode_15, flexinode_14.textual_data AS flexinode_14, flexinode_8.serialized_data AS flexinode_8, , , flexinode_12.textual_data AS flexinode_12, flexinode_12.numeric_data AS flexinode_12_format FROM credo_node n LEFT JOIN credo_flexinode_data flexinode_17 ON n.nid = flexinode_17.nid AND flexinode_17.field_id = 17 LEFT JOIN credo_flexinode_data flexinode_7 ON n.nid = flexinode_7.nid AND flexinode_7.field_id = 7 LEFT JOIN credo_flexinode_data flexinode_10 ON n.nid = flexinode_10.nid AND flexinode_10.field_id = 10 LEFT JOIN credo_flexinode_data flexinode_15 ON n.nid = flexinode_15.nid AND flexinode_15.field_id = 15 LEFT JOIN credo_flexinode_data flexinode_14 ON n.nid = flexinode_14.nid AND flexinode_14.field_id = 14 LEFT JOIN credo_flexinode_data flexinode_8 ON n.nid = flexinode_8.nid AND flexinode_8.field_id = 8 LEFT JOIN credo_flexinode_data flexinode_9 ON n.nid = flexinode_9.nid AND flexinode_9.field_id = 9 LEFT JOIN credo_flexinode_data flexinode_16 ON n.nid = flexinode_16.nid AND flexinode_16.field_id = 16 LEFT JOIN credo_flexinode_data flexinode_12 ON n.nid = flexinode_12.nid AND flexinode_12.field_id = 12 WHERE n.nid = 132 in E:\xampplite\htdocs\upgrade47\includes\database.mysql.inc on line 120.* I found though that flexinode v 1.79 2006/06/28 13:07:13 (CVS version) works just fine.
I'm running, (on Win XP):
ApacheFriends XAMPP Lite version 1.4.16
+ Apache 2.0.54
+ MySQL 4.1.14
+ PHP 5.0.5 + PEAR (basis package)
* My database has charset latin1_swedish_ci
* The content contains swedish letters
Comments
#1
probably you use a field type removed from 4.7.0 like file, multiselect, mp3 ...
#2
Got same problem after migration from drupal 4.6.5 to 4.7.3.
Using CSV V 1.79 don't help.
Just delete a "File" type field and run update.php from level 1 => That run !
Just have now to upload again 50 files .... ,=((
#3
I don't suppose one of you could help a newbie with this.
I'm running 4.7.2 and have downloaded and installed the flexinode module files (the 4.7 version, not the 4.6 which is still pointed to in one instance) "field_file.inc" is missing from the .tar file and I get the following message when I go to my site:
user warning: Table 'clearnet_drpl3.flexinode_type' doesn't exist query: SELECT * FROM flexinode_type in /home/clearnet/public_html/cosmicgumbo/includes/database.mysql.inc on line 120.
Any guidance would be appreicated. Thx.
#4
I came across the same problem while working on a clients site. I found that flexinode was flailing when I had too many fields in a content type. When i deleted a bunch of the fields it stopped giving me that error. I'm still not sure what the problem was but reducing the amount of fields in my content type temporarily fixed it. I'm assuming that it may not be flexinode, but actually the sql timing out because it is joining more than 61 tables and can't have that many table joining. An error i saw at another point during this issue.
If someone could give a better idea of what is going on that owuld be great. I myself would like to add more fields to one of my content types.
#5
Issue out of date.