upgrade to Alpha throw this:

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 'TO protected_node_passwd' at line 1 query: ALTER TABLE protected_nodes RENAME passwd TO protected_node_passwd in D:\wamp\www\xxx\sites\all\modules\protected_node\protected_node.install on line 228.

and then: user warning: Unknown column 'protected_node_passwd' in 'where clause' query: SELECT COUNT(nid) FROM protected_nodes WHERE protected_node_is_protected = 1 AND protected_node_passwd = '' in

Comments

AlexisWilke’s picture

AlexisWilke commented
Assigned: Unassigned » AlexisWilke
Status: Active » Fixed

Hi eL,

This is fixed in the 6.x-1.x-dev version.

The code works for PostgreSQL, I did not realize at the time that MySQL would have a different syntax to rename a column.

To fix the problem in that install you can run the update 6000 of 6.x-1.x-dev or simply rename the column by hand. Then the errors such as the SELECT COUNT(nid) will disappear.

Thank you for testing and reporting the problem!
Alexis Wilke

I create 6.x-1.x-alpha2 -- however, note that there isn't a new update since the previous update was "broken" I fixed that one instead; if you run it again, the RENAME will work (assuming you didn't change the table name by hand) and pretty much everything else will fail; of course, restoring your database from before the upgrade would work better and prove that alpha2 has the correct fix.

AlexisWilke’s picture

AlexisWilke commented

Sorry, alpha2 still has a problem, I'm adding alpha3 now.

Thank you.
Alexis Wilke.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.