Originally Posted by
Brent
OK I ran the following and it seems to have worked the second time. Looking in phpMyAdmin the table has been updated.
PHP Code:
ALTER TABLE orders MODIFY shipping_method VARCHAR(255) NOT NULL DEFAULT '';
Umm, but if the above query were to be run specifically against this database knowing the information from both posts, then the query should have been as entered in phpmyadmin:
PHP Code:
ALTER TABLE zen_orders MODIFY shipping_method VARCHAR(255) NOT NULL DEFAULT '';
Adding the prefix of zen_ to the table name as reported from the first post.
Therefore, question whether the verification of the update was correct and if the action really took place. (or, that there was a slight mistake in posting, not sure which or what elese it may have been.)
Bookmarks