Important Notice: Effective immediately, all support will be handled through Discord. Read more about the changes coming to Anodyne's services.

SQL UPDATE Error 1054

Having a problem getting Nova installed? Can't figure out why something isn't working right? This is the place to get help and report any bugs you find with Nova!

Nautilus_Admin_3 Sat Jan 11, 2014 5:23 am

SQL UPDATE Error 1054

Site: USS Nautilus
Whilst trying to perform a modification to the site manifests section to add the manifest metadata, an update that apparently involves modifying the database, and table structure, as apposed to adding records, the error 1054 was thrown.


A Database Error Occurred

Error Number: 1054

Unknown column 'manifest_metadata' in 'field list'

UPDATE `nova_manifests` SET `manifest_name` = 'Primary Manifest', `manifest_order` = '0', `manifest_display` = 'y', `manifest_default` = 'n', `manifest_desc` = 'This is the primary manifest used by the sim.', `manifest_header_content` = 'Update your manifest header content from the manifest management page.', `manifest_view` = '$(\'tr.active\').show();,$(\'tr.npc\').show();', `manifest_metadata` = 'species|gender' WHERE `manifest_id` = '1'

Filename: /home/thedocne/public_html/uss_nautilus/nova/modules/core/models/nova_depts_model.php

Line Number: 173

See Screenshots 1 and 2
Screenshot 1 http://thedocnetwork.net/uss_nautilus/Error%20Screenshots/Error_Screenshot1.png
Screenshot 2 http://thedocnetwork.net/uss_nautilus/Error%20Screenshots/Error_Screenshot2.png

We checked the System Information & Version History Section and everything seems to be fine
See Screenshot 3

Screenshot3 http://thedocnetwork.net/uss_nautilus/Error%20Screenshots/Error_Screenshot3.png

Now the crew manifest has disappeared and we cannot add another as the following error is thrown.


A Database Error Occurred

Error Number: 1054

Unknown column 'manifest_metadata' in 'field list'

INSERT INTO `nova_manifests` (`manifest_name`, `manifest_order`, `manifest_desc`, `manifest_header_content`, `manifest_view`, `manifest_metadata`) VALUES ('Test', '99', 'dfsajkl', 'sdfjagiosa', '$(\'tr.npc\').show();', '')

Filename: /home/thedocne/public_html/uss_nautilus/nova/modules/core/models/nova_depts_model.php

Line Number: 153

See Screenshots 4 and 5

Screenshot 4 http://thedocnetwork.net/uss_nautilus/Error%20Screenshots/Error_Screenshot4.png
Screenshot 5 http://thedocnetwork.net/uss_nautilus/Error%20Screenshots/Error_Screenshot5.png

We then tried to re-install/update the site so as to fix the database issues and received a warning telling us we had a database version of .., and a site version of 2.3.0. when we tried to install the site we got the following error.


A Database Error Occurred

Error Number: 1060

Duplicate column name 'rankcat_genre'

ALTER TABLE `nova_catalogue_ranks` ADD `rankcat_genre` VARCHAR(10) DEFAULT 'ds9' NOT NULL

Filename: /home/thedocne/public_html/uss_nautilus/nova/modules/assets/update/update_101.php

Line Number: 135

See Screenshots 6 and 7

Screenshot 6 http://thedocnetwork.net/uss_nautilus/Error%20Screenshots/Error_Screenshot6.png
Screenshot 7 http://thedocnetwork.net/uss_nautilus/Error%20Screenshots/Error_Screenshot7.png

Posts: 6


AgentPhoenix Sat Jan 11, 2014 6:43 pm

Re: SQL UPDATE Error 1054

It looks like you did run the update to get up to 2.3, or if you did, it didn't complete properly. You can try to run it again and see if that solves the issue.
User avatar

Posts: 7596


Nautilus_Admin_3 Sun Jan 12, 2014 5:47 am

Re: SQL UPDATE Error 1054

We ended up resolving the issue. We couldn't re-install because the PHP scripting kept failing during the install. We ended up taking the drastic action of re-installing nova in another directory and database, then importing the user, character and post details that we required from the original database. This then required us to force a password reset for each user as the password hashing for the original passwords didn't work in the new database. We also had to bring the user preferences table from the original database as this held the contact preferences for the users.

Posts: 6


AgentPhoenix Sun Jan 12, 2014 10:04 am

Re: SQL UPDATE Error 1054

Was this the only error you were getting during install or were there others?
User avatar

Posts: 7596


Nautilus_Admin_3 Sun Jan 12, 2014 10:34 pm

Re: SQL UPDATE Error 1054

This was not the only issue we had, we had 1054 issues with a number of tables, we tried removing the tuples that were conflicting with the update but that caused it's own host of problems.

Posts: 6


AgentPhoenix Mon Jan 13, 2014 7:51 am

Re: SQL UPDATE Error 1054

Yeah, the only way you're gonna get those types of errors is if the update was attempted and then tried again. The database forge isn't smart enough to know to not try to add a column that already exists. It should fail gracefully, but it doesn't.

Glad you got it sorted out.
User avatar

Posts: 7596


jasoncollege24 Thu Jan 16, 2014 7:27 pm

Re: SQL UPDATE Error 1054

i had an identical issue during an update from an earlier version of Nova at one point. I resolved it by removing the table it was trying to add. When that didn't work, I just restored the original database, then checked the original files, and changed the database version to match what was listed in the files for that version of Nova, and that fixed it

In that particular experience, the installer was trying to add something to the database that wasn't present in an earlier version of Nova, because it thought it was running a version of Nova that didn't have what it was trying to add.
Image
User avatar

Posts: 184


AgentPhoenix Thu Jan 16, 2014 8:06 pm

Re: SQL UPDATE Error 1054

Thankfully these shouldn't be issues in Nova 3 because of the move over to migrations (at least I haven't seen anything so far as I've been working on it).
User avatar

Posts: 7596


jasoncollege24 Thu Jan 16, 2014 9:06 pm

Re: SQL UPDATE Error 1054

speaking of that, the Nova 3 link at the top of the main Anodyne page doesn't work. I had to type in the URL manually to go there to get the preview. Just thought you'd want to know about that.
Image
User avatar

Posts: 184


AgentPhoenix Thu Jan 16, 2014 10:57 pm

Re: SQL UPDATE Error 1054

Should be all set now. Thanks for the heads up.
User avatar

Posts: 7596


jasoncollege24 Fri Jan 17, 2014 7:22 am

User avatar

Posts: 184



Return to Help

Who is online

Users browsing this forum: No registered users and 2 guests

cron