Database Error: 1054

Post Reply
thaymaker
Investor
Investor
Posts: 37
Joined: 01 Nov 2016, 20:14
Name: Teresa Haymaker
Location: USA Denver
Company Name: Cut Apart Metal Art
Contact:

Database Error: 1054

Post by thaymaker »

When upgrading 2.9.2 to 3.0 I get the following: Database Error: 1054 - Unknown column 'parent_id' in 'where clause'
Query: select * from app_forms_tabs where parent_id=0 and entities_id=43 order by sort_order, name
Page: /ruko3.0/index.php?module=items/info&path=43-1410&redirect_to=subentity&gotopage[3813]=1

download/file.php?mode=view&id=5003
Attachments
Screenshot.pdf
(122.77 KiB) Downloaded 138 times
User avatar
support
Site Admin
Posts: 6231
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Database Error: 1054

Post by support »

Looks like not all db updates was applied. Open phpmyadmin, select your database and run next query:

Code: Select all

ALTER TABLE `app_forms_tabs` ADD `parent_id` INT NOT NULL DEFAULT '0' AFTER `entities_id`, ADD `is_folder` TINYINT(1) NOT NULL DEFAULT '0' AFTER `parent_id`;
Post Reply