Mod Quotes problem ERROR

I have a problem

I can not install mod. quotes

appear this message:

Instalación de: Quotes No se pudo

INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES('index', '1140px', 'Daily Quotes', '_bx_quotes_bcaption_quotes', 2, @iPageColumnOrder, 'PHP', 'return BxDolService::call(''quotes'', ''get_quote_unit'');', 1, 28.1, 'non,memb', 0);

Hmm. A identical post in the Spanish forum from a different account. And both error messages in Spanish no less.

I am guessing you have two accounts here?

Anyhow. Should be no reason for that error to occur unless the variable in the query @iPageColumnOrder is null. And the only reason i could see that that would be null is if it could not get the column order on the index page which should not happen unless there is no column 2 on the index page.

Have you removed the second column from your index page by any chance?

Yess

 I send photo.

in my template red supernova mastertheme in homepage are only 1 column, but in my page  see 2 or 3 column.

www.parejaspapua.com

solution?

That is the reason it fails. The mod assumes two columns in the page builder because by default the quotes block goes on the second column. This may happen when installing any module that normally would place blocks in the second column of a page that by default normally has two columns.

To fix. edit modules\boonex\quotes\install\sql\install.sql

Look for this.

SET @iPageColumnOrder := (SELECT `Order` + 1 FROM `sys_page_compose` WHERE `Page` = 'index' AND `Column` = 2 ORDER BY `Order` DESC LIMIT 1);


Change the 2 to a 1 like so.

SET @iPageColumnOrder := (SELECT `Order` + 1 FROM `sys_page_compose` WHERE `Page` = 'index' AND `Column` = 1 ORDER BY `Order` DESC LIMIT 1);

Then try installing again.

WOWWW   ARE THE BEST DEANO

NOW IT'S  OK

THANK YOU VERY VERY MUCH

Welcome. There was another line that should have been changed, but i knew it would self correct, so i did not bother to make it more complicated.