Jump to:
| Project: | Flexinode |
| Version: | 4.7.x-0.1 |
| Component: | Update and installation script |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Issue Summary
I recently tried to upgrade my 4.7 site from a recent prior version (downloaded approximately two weeks ago, perhaps) to the new 4.7 release version, and I am getting SQL errors on a page that lists my flexinodes using the Views module. I ran the upgrade.php file and it did not detect any new modules that required upgrading. The two modules have peacefully coexisted on my site for months prior to this. A representative error message is here:
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 ' FROM node n LEFT JOIN flexinode_data flexinode_27 ON n.nid = flexinode_27.nid ' at line 1 query: flexinode_load SELECT flexinode_27.textual_data AS flexinode_27, flexinode_23.textual_data AS flexinode_23, flexinode_23.numeric_data AS flexinode_23_format, , FROM node n LEFT JOIN flexinode_data flexinode_27 ON n.nid = flexinode_27.nid AND flexinode_27.field_id = 27 LEFT JOIN flexinode_data flexinode_23 ON n.nid = flexinode_23.nid AND flexinode_23.field_id = 23 LEFT JOIN flexinode_data flexinode_24 ON n.nid = flexinode_24.nid AND flexinode_24.field_id = 24 LEFT JOIN flexinode_data flexinode_25 ON n.nid = flexinode_25.nid AND flexinode_25.field_id = 25 WHERE n.nid = 236 in /home/trained/public_html/includes/database.mysql.inc on line 121.
Any ideas?
Comments
#1
What fields are you using with the flexinode-node-types that cause that error?
#2
The fields that the nodes giving the error has are Email address, Postal Address, a text field and a text area.
#3
Postal Address is not yet released.
Make sure you either have it removed (and all the nodes using it fixed) or you uplaod it by hand.
Most probably the field is no longer on your server, causing the data to act wierd and causing the errors.
#4
Thanks for looking into this. I deleted the Postal Address field and it is still making the error. I reverted to the old version of the software and everything still works fine.....
#5
I tried the latest 4.7 version of Flexinode today and got the same sort of errors. I was also able to go back to the older version of Flexinode with no problems.
The node type that I tested contained a text field, a text area and an email address.