xoops forums

Mamba

Moderator
Posted on: 7/8 16:09
Mamba
Mamba (Show more)
Moderator
Posts: 10633
Since: 2004/4/23
#1

eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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.9 | Docs | Modules | Bugs

Mamba

Moderator
Posted on: 7/8 19:11
Mamba
Mamba (Show more)
Moderator
Posts: 10633
Since: 2004/4/23
#2

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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.9 | Docs | Modules | Bugs

Mamba

Moderator
Posted on: 7/9 14:05
Mamba
Mamba (Show more)
Moderator
Posts: 10633
Since: 2004/4/23
#3

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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.9 | Docs | Modules | Bugs

Mamba

Moderator
Posted on: 7/11 15:44
Mamba
Mamba (Show more)
Moderator
Posts: 10633
Since: 2004/4/23
#4

Re: eCommerce Oledrion MyShop 2.35 Beta 3 for PHP 5.6 - 7.3

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.9 | Docs | Modules | Bugs

audizioni

Just popping in
Posted on: 8/28 10:05
audizioni
audizioni (Show more)
Just popping in
Posts: 7
Since: 2009/1/11
#5

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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.
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

Mamba

Moderator
Posted on: 8/29 21:23
Mamba
Mamba (Show more)
Moderator
Posts: 10633
Since: 2004/4/23
#6

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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.9 | Docs | Modules | Bugs

audizioni

Just popping in
Posted on: 8/31 19:42
audizioni
audizioni (Show more)
Just popping in
Posts: 7
Since: 2009/1/11
#7

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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_datasess_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 ASCmid ASC
0.003741 
SELECT FROM `xcenter_xcenterWHERE (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_textWHERE (storyid '60' AND language 'italian')
0.000306 SELECT FROM `xcenter_textWHERE (storyid '6' AND language 'italian')
0.000298 SELECT FROM `xcenter_textWHERE (storyid '52' AND language 'italian')
0.000302 SELECT FROM `xcenter_textWHERE (storyid '65' AND language 'italian')
0.000336 SELECT FROM `xcenter_textWHERE (storyid '62' AND language 'italian')
0.000306 SELECT FROM `xcenter_textWHERE (storyid '63' AND language 'italian')
0.000316 SELECT FROM `xcenter_textWHERE (storyid '61' AND language 'italian')
0.000345 SELECT FROM `xcenter_textWHERE (storyid '59' AND language 'italian')
0.000294 SELECT FROM `xcenter_textWHERE (storyid '54' AND language 'italian')
0.000292 SELECT FROM `xcenter_textWHERE (storyid '55' AND language 'italian')
0.000299 SELECT FROM `xcenter_textWHERE (storyid '56' AND language 'italian')
0.000546 SELECT FROM `xcenter_textWHERE (storyid '57' AND language 'italian')
0.000292 SELECT FROM `xcenter_textWHERE (storyid '58' AND language 'italian')
0.000301 SELECT FROM `xcenter_textWHERE (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_catORDER 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

Mamba

Moderator
Posted on: 9/1 2:02
Mamba
Mamba (Show more)
Moderator
Posts: 10633
Since: 2004/4/23
#8

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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.9 | Docs | Modules | Bugs

audizioni

Just popping in
Posted on: 9/2 7:53
audizioni
audizioni (Show more)
Just popping in
Posts: 7
Since: 2009/1/11
#9

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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 QueryThere 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_idINT(11UNSIGNED NOT NULL AUTO_INCREMENT, `product_cidINT(5UNSIGNED NOT NULL DEFAULT '0', `product_titleVARCHAR(255NOT NULL DEFAULT '', `product_vendor_idINT(10UNSIGNED NOT NULL DEFAULT '0', `product_skuVARCHAR(60NOT NULL DEFAULT '', `product_extraidVARCHAR(50NOT NULL DEFAULT '', `product_widthVARCHAR(50NOT NULL DEFAULT '', `product_lengthVARCHAR(50NOT NULL DEFAULT '', `product_unitmeasure1VARCHAR(20NOT NULL DEFAULT '', `product_urlVARCHAR(255NOT NULL DEFAULT '', `product_url2VARCHAR(255NOT NULL DEFAULT '', `product_url3VARCHAR(255NOT NULL DEFAULT '', `product_image_urlVARCHAR(255NOT NULL DEFAULT '', `product_thumb_urlVARCHAR(255NOT NULL DEFAULT '', `product_submitterINT(11UNSIGNED NOT NULL DEFAULT '0', `product_onlineTINYINT(1NOT NULL DEFAULT '0', `skip_packingTINYINT(1NOT NULL DEFAULT '0', `skip_locationTINYINT(1NOT NULL DEFAULT '0', `skip_deliveryTINYINT(1NOT NULL DEFAULT '0', `product_dateVARCHAR(255NOT NULL DEFAULT '', `product_submittedINT(10UNSIGNED NOT NULL DEFAULT '0', `product_hitsINT(11UNSIGNED NOT NULL DEFAULT '0', `product_ratingINT(11UNSIGNED NOT NULL DEFAULT '0', `product_votesINT(11UNSIGNED NOT NULL DEFAULT '0', `product_commentsINT(11UNSIGNED NOT NULL DEFAULT '0', `product_priceDECIMAL(162NOT NULL DEFAULT '0', `product_shipping_priceDECIMAL(162NOT NULL DEFAULT '0', `product_discount_priceDECIMAL(162NOT NULL DEFAULT '0', `product_stockMEDIUMINT(8UNSIGNED NOT NULL DEFAULT '0', `product_alert_stockMEDIUMINT(8UNSIGNED NOT NULL DEFAULT '0', `product_summaryTEXT, `product_descriptionTEXT, `product_attachmentVARCHAR(255NOT NULL DEFAULT '', `product_weightVARCHAR(20NOT NULL DEFAULT '', `product_unitmeasure2VARCHAR(20NOT NULL DEFAULT '', `product_vat_idMEDIUMINT(8UNSIGNED NOT NULL DEFAULT '0', `product_download_urlVARCHAR(255NOT NULL DEFAULT '', `product_recommendedDATE NOT NULL, `product_metakeywordsVARCHAR(255NOT NULL DEFAULT '', `product_metadescriptionVARCHAR(255NOT NULL DEFAULT '', `product_metatitleVARCHAR(255NOT NULL DEFAULT '', `product_delivery_timeMEDIUMINT(8UNSIGNED NOT NULL DEFAULT '0', `product_ecotaxeDECIMAL(162NOT NULL DEFAULT '0', `product_property1VARCHAR(255NOT NULL DEFAULT '', `product_property2VARCHAR(255NOT NULL DEFAULT '', `product_property3VARCHAR(255NOT NULL DEFAULT '', `product_property4VARCHAR(255NOT NULL DEFAULT '', `product_property5VARCHAR(255NOT NULL DEFAULT '', `product_property6VARCHAR(255NOT NULL DEFAULT '', `product_property7VARCHAR(255NOT NULL DEFAULT '', `product_property8VARCHAR(255NOT NULL DEFAULT '', `product_property9VARCHAR(255NOT NULL DEFAULT '', `product_property10VARCHAR(255NOT 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 largeThe maximum column size is 767 bytes.[/color]

Mamba

Moderator
Posted on: 9/2 8:38
Mamba
Mamba (Show more)
Moderator
Posts: 10633
Since: 2004/4/23
#10

Re: eCommerce Oledrion MyShop 2.35 Beta 1 for PHP 5.6 - 7.3

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.9 | Docs | Modules | Bugs