You get what you pay for.AvanOsch wrote:Yeah, I'm guessing these people know that...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.
They probably just don't want to pay 20 bucks
-Ryan
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
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!
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!
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.
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.
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...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
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:
Here's oc_banner structure
and oc_banner_image structure
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
and oc_banner_image structure
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
additionaly if I disable the mod, add banner than enable mod I get this in link field:
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 49Code: 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>
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)
THEN, if you want the Original OpenCart banners:
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;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');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!
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!
No errors in logs
Also error when trying to edit existing banner (added after clean install):
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
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
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
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...
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...
Who is online
Users browsing this forum: No registered users and 12 guests
