By giucas on

I'm using a test site to upgrade from 4.6 to 4.7.4 release. The (first) problem I get is flexinode dosn't work and shots many of these warnings:

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_5 ON n.nid = flexinode_5.nid AND ' at line 1 query: SELECT flexinode_5.serialized_data AS flexinode_5, flexinode_4.textual_data AS flexinode_4, flexinode_4.numeric_data AS flexinode_4_format, FROM node n LEFT JOIN flexinode_data flexinode_5 ON n.nid = flexinode_5.nid AND flexinode_5.field_id = 5 LEFT JOIN flexinode_data flexinode_4 ON n.nid = flexinode_4.nid AND flexinode_4.field_id = 4 LEFT JOIN flexinode_data flexinode_10 ON n.nid = flexinode_10.nid AND flexinode_10.field_id = 10 WHERE n.nid = 243 in /var/www/default/drupal-4.7.4/includes/database.mysql.inc on line 121.

As you can see the syntax of the query is wrong (there is a comma before the FROM keyword). Does anyone know why I get these errors and how to fix the problem? (yes I run the update.php script)

thx
giucas

⋅ Categories: Drupal 4.7.x

Comments

netceo’s picture

netceo commented

Hi giucas, i faced similar problems with flexinode until i came up with a home grown solution. Use your old 4.6 db and upgrade it to 4.7 instead of creating a new one and installing flexinode module... it will work..by that i mean install flexinode on 4.6, create your custom node types and then upgrade to 4.7. In the end install the flexinode module.. it works..

NetCEO