XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. XOOPS Module Development
  4. Module Testing Area 
  5.  / eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3
Register
1
Mamba
eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/7/8 16:09

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Resized Image

Oledrion, the eCommerce module originally developed for XOOPS by Hervet, has been updated for XOOPS 2.5.9 and PHP 7.2. It has been also tested on PHP 7.3.0 Alpha 3, and so far everything was working just fine.

In the Alpha release we've added namespaces and class autoloading. Because of that, bugs are possible, therefore please test it and submit your fixes and improvements, as we're entering into the Beta phase.

REQUIREMENTS: Minimum PHP 5.6

TUTORIAL: click here

DEMO: click here

DOWNLOAD: click here

FORK: GitHub

Here is a brief summary of its features:

1/ Vendors manager
2/ VAT (Value Added Tax) manager
3/ Categories manager
4/ Manufacturers manager
5/ Advanced products management (with the possibility of linking an unlimited number of files for each product)
6/ Orders manager
7/ A very advanced Discounts manager
8/ Newsletter
9/ Inventory Control
10/ Online and off-line payment
11/ Use an internal cache to limit Mysql queries
12/ RSS
13/ Integrated with the XOOPS search (and advanced search)
14/ Notifications system for sales
15/ Several blocks
16/ Integration of the XOOPS comments
17/ URL Rewriting
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
2
Mamba
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/7/8 19:11

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Rossb found some bugs in the installation, so I just fixed that and released a Beta 2

It's always nice to have the support from the community helping us with bug hunting and reporting back.

THANK YOU!!!

And Happy testing!
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
3
Mamba
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/7/9 14:05

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Once you install it, you can go to Preferences, and set the "Show Sample Button?" to yes, and save it.

Resized Image

Then in the Admin click on the "Import Sample Data"

Resized Image

And Oledrion will get populated with sample data, which should make your testing easier.
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
4
Mamba
Re: eCommerce Oledrion MyShop 2.35 Beta 3 for PHP 5.6 - 7.3

  • 2018/7/11 15:44

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


eCommerce Oledrion MyShop 2.35 Beta 3 for PHP 5.6 - 7.3 has been released for testing

Download: https://github.com/XoopsModules25x/oledrion/releases/

Thanks to Bill for testing and for improvements! Open Source does work!

And it's always nice to see when XOOPS modules are working :

Resized Image
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
5
audizioni
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/8/28 10:05

  • audizioni

  • Just popping in

  • Posts: 17

  • Since: 2009/1/11


I tried to install Oledrion MyShop 2.35 Beta 3. This error is reported to me: Index column size too large. The maximum column size is 767 bytes.
http://www.audizioni.it

Versione XOOPS XOOPS 2.5.9
Versione PHP 7.1.20
Versione mySQL 5.6.39-83.1-log
Server API cgi-fcgi
Sistema operativo Linux
allow_url_fopen On
fsockopen On
post_max_size 30M
max_input_time 60
output_buffering 4096
max_execution_time 900
memory_limit 256M
file_uploads On
upload_max_filesize 50M

what should I do?
regards, Giuseppe
6
Mamba
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/8/29 21:23

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


1) what kind of collation do you use in your database?

2) when you're installing, and you see this error, please click on the Queries () link at the bottom, because normally it points exactly which table caused the issue.

Please then post it here...
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
7
audizioni
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/8/31 19:42

  • audizioni

  • Just popping in

  • Posts: 17

  • Since: 2009/1/11


Collation: utf8_general_ci

.000288 - SET SQL_BIG_SELECTS = 1
0.000397 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000375 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'b17f805aab9e0778c8d8568dfd4fc7e2'
0.000291 - SELECT * FROM users WHERE uid = '1'
0.000273 - SELECT * FROM modules WHERE dirname = 'system'
0.000337 - SELECT * FROM config WHERE (conf_modid = '1') ORDER BY conf_order ASC
0.000395 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0.000399 - SELECT COUNT(*) FROM protector_access WHERE ip='xxxxxxx' AND request_uri='/site/modules/system/admin.php?fct=modulesadmin&op=install&module=oledrion'
0.000392 - SELECT COUNT(*) FROM protector_access WHERE ip='xxxxxx'
0.000439 - INSERT INTO protector_access SET ip='xxxxxxx', request_uri='/site/modules/system/admin.php?fct=modulesadmin&op=install&module=oledrion', expire=UNIX_TIMESTAMP()+'60'
0.000325 - SELECT * FROM modules WHERE dirname = 'oledrion'
0.000271 - SELECT * FROM groups WHERE (group_type = 'Admin')
0.000275 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '5') ORDER BY conf_order ASC
0.000291 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000424 - SELECT * FROM modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
0.003741 - SELECT * FROM `xcenter_xcenter` WHERE (submenu = '1' AND parent_id = '0' AND visible = '1' AND (publish < '1535744121' OR publish = '0') AND (expire > '1535744121' OR expire = '0'))
0.000272 - SELECT * FROM modules WHERE dirname = 'xcenter'
0.000328 - SELECT * FROM `xcenter_text` WHERE (storyid = '60' AND language = 'italian')
0.000306 - SELECT * FROM `xcenter_text` WHERE (storyid = '6' AND language = 'italian')
0.000298 - SELECT * FROM `xcenter_text` WHERE (storyid = '52' AND language = 'italian')
0.000302 - SELECT * FROM `xcenter_text` WHERE (storyid = '65' AND language = 'italian')
0.000336 - SELECT * FROM `xcenter_text` WHERE (storyid = '62' AND language = 'italian')
0.000306 - SELECT * FROM `xcenter_text` WHERE (storyid = '63' AND language = 'italian')
0.000316 - SELECT * FROM `xcenter_text` WHERE (storyid = '61' AND language = 'italian')
0.000345 - SELECT * FROM `xcenter_text` WHERE (storyid = '59' AND language = 'italian')
0.000294 - SELECT * FROM `xcenter_text` WHERE (storyid = '54' AND language = 'italian')
0.000292 - SELECT * FROM `xcenter_text` WHERE (storyid = '55' AND language = 'italian')
0.000299 - SELECT * FROM `xcenter_text` WHERE (storyid = '56' AND language = 'italian')
0.000546 - SELECT * FROM `xcenter_text` WHERE (storyid = '57' AND language = 'italian')
0.000292 - SELECT * FROM `xcenter_text` WHERE (storyid = '58' AND language = 'italian')
0.000301 - SELECT * FROM `xcenter_text` WHERE (storyid = '64' AND language = 'italian')
0.000261 - SELECT * FROM modules WHERE dirname = 'tag'
0.000299 - SELECT * FROM modules WHERE mid = 36
0.000335 - SELECT * FROM modules WHERE dirname = 'xnewsletter'
0.000218 - SELECT groupid FROM groups_users_link WHERE uid=1
0.000259 - SELECT * FROM `xnewsletter_cat` ORDER BY cat_id ASC
0.000350 - SELECT * FROM config WHERE (conf_modid = '89') ORDER BY conf_order ASC
0.000271 - SELECT * FROM groups WHERE group_type = 'Broker'
0.000224 - SELECT * FROM groups WHERE group_type = 'Accounts'
0.000226 - SELECT * FROM groups WHERE group_type = 'Officer'
0.000252 - SELECT * FROM modules WHERE dirname = 'xpayment'
0.000303 - SELECT * FROM config WHERE (conf_modid = '91' AND conf_catid = '0') ORDER BY conf_order ASC
0.000262 - SELECT * FROM modules WHERE mid = 91
0.000257 - SELECT * FROM modules WHERE dirname = 'profile'
0.000283 - SELECT * FROM modules WHERE dirname = 'protector'
0.000256 - SELECT * FROM modules WHERE mid = 4
0.000317 - SELECT * FROM modules WHERE dirname = 'adslight'
0.000259 - SELECT * FROM modules WHERE dirname = 'contact'
0.000265 - SELECT * FROM modules WHERE dirname = 'pm'
0.000278 - SELECT * FROM modules WHERE dirname = 'news'
0.000341 - SELECT * FROM config WHERE (conf_modid = '78') ORDER BY conf_order ASC
0.000260 - SELECT * FROM modules WHERE dirname = 'mylinks'
0.000316 - SELECT * FROM config WHERE (conf_modid = '67') ORDER BY conf_order ASC
8
Mamba
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/9/1 2:02

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


I don't see the error here: "Index column size too large"

Can you try to replicate it and post again with the full error message?
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
9
audizioni
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/9/2 7:53

  • audizioni

  • Just popping in

  • Posts: 17

  • Since: 2009/1/11


Thank you.
Yes. This is the message:

"[color=000066]Impossibile installare oledrion. Errore(i):
Installazione in corso eCommerce

Index column size too large. The maximum column size is 767 bytes[/color]."

This the Query; There are new messages!:

0.000240 - SET SQL_BIG_SELECTS = 1
0.000428 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
[color=0066CC]0.011727 - CREATE TABLE oledrion_products ( `product_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `product_cid` INT(5) UNSIGNED NOT NULL DEFAULT '0', `product_title` VARCHAR(255) NOT NULL DEFAULT '', `product_vendor_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', `product_sku` VARCHAR(60) NOT NULL DEFAULT '', `product_extraid` VARCHAR(50) NOT NULL DEFAULT '', `product_width` VARCHAR(50) NOT NULL DEFAULT '', `product_length` VARCHAR(50) NOT NULL DEFAULT '', `product_unitmeasure1` VARCHAR(20) NOT NULL DEFAULT '', `product_url` VARCHAR(255) NOT NULL DEFAULT '', `product_url2` VARCHAR(255) NOT NULL DEFAULT '', `product_url3` VARCHAR(255) NOT NULL DEFAULT '', `product_image_url` VARCHAR(255) NOT NULL DEFAULT '', `product_thumb_url` VARCHAR(255) NOT NULL DEFAULT '', `product_submitter` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_online` TINYINT(1) NOT NULL DEFAULT '0', `skip_packing` TINYINT(1) NOT NULL DEFAULT '0', `skip_location` TINYINT(1) NOT NULL DEFAULT '0', `skip_delivery` TINYINT(1) NOT NULL DEFAULT '0', `product_date` VARCHAR(255) NOT NULL DEFAULT '', `product_submitted` INT(10) UNSIGNED NOT NULL DEFAULT '0', `product_hits` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_rating` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_votes` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_comments` INT(11) UNSIGNED NOT NULL DEFAULT '0', `product_price` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_shipping_price` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_discount_price` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_stock` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_alert_stock` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_summary` TEXT, `product_description` TEXT, `product_attachment` VARCHAR(255) NOT NULL DEFAULT '', `product_weight` VARCHAR(20) NOT NULL DEFAULT '', `product_unitmeasure2` VARCHAR(20) NOT NULL DEFAULT '', `product_vat_id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_download_url` VARCHAR(255) NOT NULL DEFAULT '', `product_recommended` DATE NOT NULL, `product_metakeywords` VARCHAR(255) NOT NULL DEFAULT '', `product_metadescription` VARCHAR(255) NOT NULL DEFAULT '', `product_metatitle` VARCHAR(255) NOT NULL DEFAULT '', `product_delivery_time` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', `product_ecotaxe` DECIMAL(16, 2) NOT NULL DEFAULT '0', `product_property1` VARCHAR(255) NOT NULL DEFAULT '', `product_property2` VARCHAR(255) NOT NULL DEFAULT '', `product_property3` VARCHAR(255) NOT NULL DEFAULT '', `product_property4` VARCHAR(255) NOT NULL DEFAULT '', `product_property5` VARCHAR(255) NOT NULL DEFAULT '', `product_property6` VARCHAR(255) NOT NULL DEFAULT '', `product_property7` VARCHAR(255) NOT NULL DEFAULT '', `product_property8` VARCHAR(255) NOT NULL DEFAULT '', `product_property9` VARCHAR(255) NOT NULL DEFAULT '', `product_property10` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`product_id`), KEY `product_cid` (`product_cid`), KEY `product_online` (`product_online`), KEY `product_title` (`product_title`), KEY `product_unitmeasure1` (`product_unitmeasure1`), KEY `product_weight` (`product_weight`), KEY `product_vendor_id` (`product_vendor_id`), KEY `product_extraid` (`product_extraid`), KEY `product_width` (`product_width`), KEY `recent_online` (`product_online`, `product_submitted`), KEY `product_recommended` (`product_recommended`), KEY `product_summary` (`product_summary` (1000)), KEY `product_description` (`product_description` (1000)) ) ENGINE = InnoDB
Error number: 1709
Error message: Index column size too large. The maximum column size is 767 bytes.[/color]
10
Mamba
Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

  • 2018/9/2 8:38

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Excellent. This is helpful, because based on this:

CREATE TABLE oledrion_products (


I know that the error is coming from "oledrion_products " table.

I'll look into it this weekend
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

410 user(s) are online (312 user(s) are browsing Support Forums)

Members: 0

Guests: 410

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits