Page 3 of 5
Re: [Extension] Banner Language
Posted: Tue Nov 13, 2012 6:42 pm
by rph
AvanOsch wrote:rph wrote:If you don't want to wait
Banners Plus has multi-language as one of its features. It's stable and has been out for 8 months now.
Yeah, I'm guessing these people know that...
They probably just don't want to pay 20 bucks
You get what you pay for.
Re: [Extension] Banner Language
Posted: Fri Nov 23, 2012 10:01 pm
by okibobo
I have a problem after installing the module using vqmod is not changed, the title is multi-lingual, but the image is always only one, then I tried to manually install and had announced to me the error Notice: Undefined index: title in ..... / banner.php on line 419Notice: Can you advise me what to do with it. I have OpenCart 1.5.4.1
Re: [Extension] Banner Language
Posted: Wed Dec 12, 2012 2:26 am
by talal
Hi there,
i am using opencart 1.5.1.3 and vqmod
there is an error after install your extension.
VQmod log.
---------- Date: 2012-12-11 17:26:32 ~ IP : 127.0.0.1 ----------
REQUEST URI : /pinkart/admin/index.php?route=design/banner/update&token=ebb30e3535d21feefd0248439139ce4e&banner_id=6
MOD DETAILS:
modFile : D:\wamp\www\pinkart\vqmod\xml\BannerLanguage.xml
id : Banner Language
version : 1.1.2
vqmver : 2.1.5
author : The Wizard of Osch, for
www.CrystalCopy.nl
SEARCH NOT FOUND (ABORTING MOD): <td class="left"><a onclick="$('#image-row<?php echo $image_row; ?>').remove();" class="button"><span><?php echo $button_remove; ?></span></a></td>
I appreciate for your help!
Re: [Extension] Banner Language
Posted: Wed Dec 12, 2012 9:43 pm
by talal
Hi there,
I am using OpenCart 1.5.1.3 and after banner language install from VQmod it nothing happen.
please see the VQmod log below.
---------- Date: 2012-12-11 17:26:32 ~ IP : 127.0.0.1 ----------
REQUEST URI : /pinkart/admin/index.php?route=design/banner/update&token=ebb30e3535d21feefd0248439139ce4e&banner_id=6
MOD DETAILS:
modFile : D:\wamp\www\pinkart\vqmod\xml\BannerLanguage.xml
id : Banner Language
version : 1.1.2
vqmver : 2.1.5
author : The Wizard of Osch, for
www.CrystalCopy.nl
SEARCH NOT FOUND (ABORTING MOD): <td class="left"><a onclick="$('#image-row<?php echo $image_row; ?>').remove();" class="button"><span><?php echo $button_remove; ?></span></a></td>
----------------------------------------------------------------------
I appreciate for you help.
Re: [Extension] Banner Language
Posted: Sat Jan 05, 2013 11:09 pm
by Shark
okibobo wrote:I have a problem after installing the module using vqmod is not changed, the title is multi-lingual, but the image is always only one, then I tried to manually install and had announced to me the error Notice: Undefined index: title in ..... / banner.php on line 419Notice: Can you advise me what to do with it. I have OpenCart 1.5.4.1
I had the same problem. You have to restore the database tables concerning banners (banner, banner_image, banner_image_description) to the original state first, then reinstall Banner Language mod...
Re: [Extension] Banner Language
Posted: Thu Jan 17, 2013 6:33 pm
by 741852963
Restoring database doesn't help. I still can't get it to work.
Re: [Extension] Banner Language
Posted: Thu Jan 17, 2013 6:52 pm
by 741852963
OK
I have clean database. I Install vqmod version. I go to system/design/banners.
I insert new banner and I have only one image option instead of two.
Nevertheless I continue and I add banner, save it and:
Code: Select all
Notice: Undefined index: title in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 420
Notice: Uninitialized string offset: 0 in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 420
Notice: Undefined index: image in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 380
Notice: Undefined index: title in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 387
Notice: Undefined index: link in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 388
Notice: Uninitialized string offset: 0 in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 380
Notice: Uninitialized string offset: 0 in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 387
Notice: Uninitialized string offset: 0 in /[...]/public_html/vqmod/vqcache/vq2-admin_controller_design_banner.php on line 388
Here's oc_banner structure
and oc_banner_image structure
Re: [Extension] Banner Language
Posted: Tue Jan 29, 2013 1:00 am
by 741852963
OK, commenting out operation starting on line 106 seems to make it somewhat better.
There are two image fields for two languages, however when I delete all banners I get this error in admin
Code: Select all
Notice: Error: Duplicate column name 'language_id'
Error No: 1060
ALTER TABLE oc_banner_image ADD language_id int(11) NOT NULL, ADD title varchar(64) COLLATE utf8_bin NOT NULL, DROP PRIMARY KEY, ADD PRIMARY KEY (`banner_image_id`, `language_id`) in /*/public_html/system/database/mysql.php on line 49
additionaly if I disable the mod, add banner than enable mod I get this in link field:
Code: Select all
<b>Notice</b>: Undefined index: 2 in <b>/*/public_html/vqmod/vqcache/vq2-admin_view_template_design_banner_form.tpl</b> on line <b>61</b>
Code: Select all
<b>Notice</b>: Undefined index: 1 in <b>/*/public_html/vqmod/vqcache/vq2-admin_view_template_design_banner_form.tpl</b> on line <b>61</b>
Re: [Extension] Banner Language
Posted: Tue Feb 26, 2013 12:16 am
by AvanOsch
Just released a new version.
It should fix all existing problems.
Sorry for the delay, and enjoy!
Re: [Extension] Banner Language
Posted: Thu Feb 28, 2013 8:11 pm
by AvanOsch
I did my best to let the new version automatically restore database entries that were changed by previous versions.
However, it seems some people got some un-expected database changes...
The SQL below is for OpenCart versions 1.5.1.x and higher. (maybe even older versions - don't know)
If you have a DATABASE PREFIX, code below won't work! Add your prefix to the table names (6x & 3x) first!
To reset your banners: (Clear all banners)
Code: Select all
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
`banner_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) COLLATE utf8_bin NOT NULL,
`status` tinyint(1) NOT NULL,
PRIMARY KEY (`banner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `banner_image`;
CREATE TABLE `banner_image` (
`banner_image_id` int(11) NOT NULL AUTO_INCREMENT,
`banner_id` int(11) NOT NULL,
`link` varchar(255) COLLATE utf8_bin NOT NULL,
`image` varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`banner_image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `banner_image_description`;
CREATE TABLE `banner_image_description` (
`banner_image_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`banner_id` int(11) NOT NULL,
`title` varchar(64) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`banner_image_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
THEN, if you want the Original OpenCart banners:
Code: Select all
INSERT INTO `banner` (`banner_id`, `name`, `status`) VALUES
(6, 'HP Products', 1),
(7, 'Samsung Tab', 1),
(8, 'Manufacturers', 1);
INSERT INTO `banner_image` (`banner_image_id`, `banner_id`, `link`, `image`) VALUES
(54, 7, 'index.php?route=product/product&path=57&product_id=49', 'data/samsung_banner.jpg'),
(77, 6, '/index.php?route=product/manufacturer/product&manufacturer_id=7', 'data/hp_banner.jpg'),
(75, 8, '/index.php?route=product/manufacturer/product&manufacturer_id=5', 'data/htc_logo.jpg'),
(73, 8, '/index.php?route=product/manufacturer/product&manufacturer_id=8', 'data/apple_logo.jpg'),
(74, 8, '/index.php?route=product/manufacturer/product&manufacturer_id=9', 'data/canon_logo.jpg'),
(71, 8, '/index.php?route=product/manufacturer/product&manufacturer_id=10', 'data/sony_logo.jpg'),
(72, 8, '/index.php?route=product/manufacturer/product&manufacturer_id=6', 'data/palm_logo.jpg'),
(76, 8, '/index.php?route=product/manufacturer/product&manufacturer_id=7', 'data/hp_logo.jpg');
INSERT INTO `banner_image_description` (`banner_image_id`, `language_id`, `banner_id`, `title`) VALUES
(54, 1, 7, 'Samsung Tab 10.1'),
(77, 1, 6, 'HP Banner'),
(75, 1, 8, 'HTC'),
(74, 1, 8, 'Canon'),
(73, 1, 8, 'Apple'),
(72, 1, 8, 'Palm'),
(71, 1, 8, 'Sony'),
(76, 1, 8, 'Hewlett-Packard');
Re: [Extension] Banner Language
Posted: Sun Mar 03, 2013 12:46 am
by muraqib
Hi,
I also installed this latest version on my 1.5.5.1 version OpenCart and when I try to add a multilanguage banner, it throws the following error:
Notice: Error: Unknown column 'link' in 'field list'
Error No: 1054
INSERT INTO slsbanner_image_description SET banner_image_id = '80', language_id = '1', banner_id = '10', title = 'New', link = '', image = 'data/banner_eng.jpg' in /.../system/database/mysql.php on line 50
I hope someone could help to find a solution!
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 7:02 am
by AvanOsch
Hi Muraqib,
That's strange...
Seems the database changes didn't go through...
Do you have any other extensions installed?
Are you using vQMod?
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 7:34 am
by 741852963
I have the same problem.
Using vqmod with 1.5.4.1 open cart version
Some other vqmods installed, however I don't think that any of them is conlicting.
There are three columns in oc_banner_image:
banner_image_id
banner_id
link
image
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 7:42 am
by AvanOsch
Yeah.
Database changes did not go through...
Any vQMod errors?
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 7:48 am
by 741852963
No errors in logs
Also error when trying to edit existing banner (added after clean install):
Code: Select all
Notice: Error: Table 'oc_banner_image_description' already exist
Error No: 1050
CREATE TABLE oc_banner_image_description (`banner_image_id` int(11) NOT NULL,`language_id` int(11) NOT NULL, `banner_id` int(11) NOT NULL, `title` varchar(64) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`banner_image_id`,`language_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin in /*/public_html/system/database/mysql.php on line 49
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 7:53 am
by AvanOsch
Weird...
Could you send me the files:
"vqmod/vqcache/admin_controller_design_banner.php"
"vqmod/vqcache/admin_model_design_banner.php"
I'll have to take a look at what is goin' on...
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 8:04 am
by 741852963
I've sent you this files by the PM (may have sent some twice by mistake).
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 8:20 am
by AvanOsch
Well, your model_design_banner.php file is empty!!!
It only contains the function "getBanner", the rest is gone!
-EDIT-
Ow, wait...
The first file you sent me is ok... (about 13kB)
Why is that one different?!?
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 5:16 pm
by 741852963
Both files were copied copied from server to my hdd and then attached in the PM. I've got some mess up due to sending two PM's to fast (anti spam filter) that's probably why you've got one file corrupted.
To be on the safe side here are the pastebin links:
http://pastebin.com/WbNeLPpY vq2-admin_controller_design_banner.php
http://pastebin.com/kPCT8ugK vq2-admin_model_design_banner.php
http://pastebin.com/JLpWU8kd vq2-admin_view_template_design_banner_form.tpl
http://pastebin.com/yxyCPny8 vq2-catalog_model_design_banner.php
Re: [Extension] Banner Language
Posted: Mon Mar 04, 2013 6:33 pm
by AvanOsch
Ow, wait... Now I see what's going on!
You also sent the catalog_model
Anyways...
With the files you sent me, there should be no problems...
All changes are applied correctly.
What other extensions do you use?
Also, I presume you visited "Admin --> System --> Design --> Banners"?
Visiting that "Banner Listing" should check for, and apply any database changes...