?
avatar grxsolution
grxsolution
13 Apr 2015

Can anyone tell me how to fix this database error?

database
Table 'bqu1s_redirect_links' does not have column 'new_url' with type 'varchar(255)'. (From file 3.4.0-2014-09-16.sql.)

avatar grxsolution grxsolution - open - 13 Apr 2015
avatar joomla-cms-bot joomla-cms-bot - change - 13 Apr 2015
Labels Added: ?
avatar zero-24
zero-24 - comment - 13 Apr 2015

Can anyone tell me how to correct this Joomla Database Error?

Try the Fix Button. :smile:

avatar zero-24 zero-24 - change - 13 Apr 2015
Status New Closed
Closed_Date 0000-00-00 00:00:00 2015-04-13 18:26:17
avatar zero-24 zero-24 - close - 13 Apr 2015
avatar zero-24 zero-24 - close - 13 Apr 2015
avatar grxsolution
grxsolution - comment - 13 Apr 2015

I did and that didn't work.

avatar zero-24
zero-24 - comment - 13 Apr 2015

I did and that didn't work.

hmm for me it works ok. And i didn't here any others that have problems with it. How do you update? Via autoupdater?

try this place /administrator/com_admin/sql/updates/mysql and execute the SQL files 3.4.0-2014-09-16.sql and 3.4.0-2015-02-26.sql to your database (replace #__ with your Database prefixes) these will fix the errors.

avatar grxsolution
grxsolution - comment - 13 Apr 2015

I did use Autoupdater. I don't understand how to do what you are suggesting. Sorry, very new to all of this. Can you explain in detailed steps? Thanks for your help.

avatar zero-24
zero-24 - comment - 13 Apr 2015

. Can you explain in detailed steps?

-Open your Databasemanagment System (e.g. phpmyadmin)
-access your database
-open the SQL Tab
-paste:

ALTER TABLE `bqu1s_redirect_links` ADD header smallint(3) NOT NULL DEFAULT 301;
ALTER TABLE `bqu1s_redirect_links` MODIFY new_url varchar(255);
INSERT INTO `bqu1s_postinstall_messages` (`extension_id`, `title_key`, `description_key`, `action_key`, `language_extension`, `language_client_id`, `type`, `action_file`, `action`, `condition_file`, `condition_method`, `version_introduced`, `enabled`) VALUES
(700, 'COM_CPANEL_MSG_LANGUAGEACCESS340_TITLE', 'COM_CPANEL_MSG_LANGUAGEACCESS340_BODY', '', 'com_cpanel', 1, 'message', '', '', 'admin://components/com_admin/postinstall/languageaccess340.php', 'admin_postinstall_languageaccess340_condition', '3.4.1', 1);
  • execute
  • try the view again.
avatar zero-24
zero-24 - comment - 13 Apr 2015

Also please use the forum http://forum.joomla.org for site specific support in the future. This here is for bugs in the CMS not for support requests. Thanks for understanding!

avatar grxsolution
grxsolution - comment - 13 Apr 2015

Will do and thanks for pointing me in the right direction! I pasted the code and executed – this error was returned:

SQL query:

ALTER TABLE bqu1s_redirect_links ADD header smallint(3) NOT NULL DEFAULT 301;

MySQL said: Documentation
#1060 - Duplicate column name 'header'

sqlerror

avatar zero-24
zero-24 - comment - 13 Apr 2015

Than remove the first line. :smile:

ALTER TABLE `bqu1s_redirect_links` MODIFY new_url varchar(255);
INSERT INTO `bqu1s_postinstall_messages` (`extension_id`, `title_key`, `description_key`, `action_key`, `language_extension`, `language_client_id`, `type`, `action_file`, `action`, `condition_file`, `condition_method`, `version_introduced`, `enabled`) VALUES
(700, 'COM_CPANEL_MSG_LANGUAGEACCESS340_TITLE', 'COM_CPANEL_MSG_LANGUAGEACCESS340_BODY', '', 'com_cpanel', 1, 'message', '', '', 'admin://components/com_admin/postinstall/languageaccess340.php', 'admin_postinstall_languageaccess340_condition', '3.4.1', 1);

as stated above please use the forum http://forum.joomla.org for site specific support. Thanks for understanding!

Add a Comment

Login with GitHub to post a comment