31
Peekay
Re: Oledrion items' limit
  • 2010/6/15 22:34

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


Quote:
Do you know what criteria is active when you display a table in PHPMyAdmin

I have been caught out by that before! The default 'sort by key' is 'none' but I don't know how PhPMyadmin decides the order that the rows are displayed if no sort key is chosen.

I have added new records when debugging and they do not always wind up at the end of the listing.
A thread is for life. Not just for Christmas.

32
ghia
Re: Oledrion items' limit
  • 2010/6/15 22:44

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
Do you know what criteria is active when you display a table in PhpMyAdmin ? I mean without any clic on the top of column. That's strange : when I order product by ID, chronological order (product_date field) is no more respected.
You must always assume a random order if not sorted by any key or field! (Probably it has to do with some physical location on the disk)

The product_date is maybe with the cloned products and equal to the one of the cloned product. (Don't know the purpose of this field)

Unless deletions, the product_id should be consecutive.

33
Burning
Re: Oledrion items' limit
  • 2010/6/15 22:57

  • Burning

  • Theme Designer

  • Posts: 1163

  • Since: 2006/8/22


Thanks Ghia :)
Now I will be more careful about random order / default key.


... last-question-about-tables

Even I sort items by product_id, when I export my product table, I have this order :
Resized Image


Is there any danger to clean it manually (in sql file) ?
Still learning CSS and... english

34
ghia
Re: Oledrion items' limit
  • 2010/6/15 23:09

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Export is about having quick all records. (Sorting takes time)
The importing application has to sort if necessary.

35
Burning
Re: Oledrion items' limit
  • 2010/6/15 23:21

  • Burning

  • Theme Designer

  • Posts: 1163

  • Since: 2006/8/22


Thanks again :)


I hope we will find a solution about oledrion product form...

I have no more idea about it, and as I have no trouble on my own sites (database I have tested is from Cinleo website), I can't replicate bug / understand anything.

It seems :
• not an issue with product_id
• not an issue with wysiwyg editor
• occurs sometimes...
Still learning CSS and... english

36
ghia
Re: Oledrion items' limit
  • 2010/6/15 23:47

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


This one?

Intermittant problems are very difficult. There is something, because several users complain about that. Odd is that when you copied the database tables, the problem did not come along. (It was not a complete database?)

37
DonCurioso
Re: Oledrion items' limit

Hi,

i did ask about it a few moths ago... https://xoops.org/modules/news/article.php?storyid=5034

And no news related...
HispaXoops | Xoops España

That's the way i like it! | Nada mejor que una Alhambra bien helada con aceitunas...

38
ghia
Re: Oledrion items' limit
  • 2010/6/16 6:58

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


We are still searching. Are you having still the problem? And want to do something about?
(The comments are not the best place to report and discuss bugs or problems)

39
Burning
Re: Oledrion items' limit
  • 2010/6/21 12:38

  • Burning

  • Theme Designer

  • Posts: 1163

  • Since: 2006/8/22


hi'

--- requests

Here requests in debug mode :
0.000177 SET NAMES 'utf8'
0.000168 SET SQL_BIG_SELECTS 1
0.001051 
SELECT FROM config WHERE (conf_modid '0' AND conf_catid '1'ORDER BY conf_order ASC
0.000369 
SELECT FROM modules WHERE dirname 'xlanguage'
0.000662 SELECT sess_datasess_ip FROM session WHERE sess_id 'xxx'
0.000481 SELECT FROM users WHERE uid '2'
0.000290 SELECT FROM modules WHERE dirname 'oledrion'
0.000585 SELECT FROM config WHERE (conf_modid '10'ORDER BY conf_order ASC
0.000755 
SHOW TABLES LIKE 'oledrion_gateways_options'
0.000544 SHOW COLUMNS FROM oledrion_commands LIKE 'cmd_comment'
0.000471 SHOW COLUMNS FROM oledrion_commands LIKE 'cmd_vat_number'
0.000395 SHOW TABLES LIKE 'oledrion_lists'
0.000743 SHOW TABLES LIKE 'oledrion_products_list'
0.000481 SHOW COLUMNS FROM oledrion_products_list LIKE 'productlist_date'
0.000353 SHOW TABLES LIKE 'oledrion_attributes'
0.000397 SHOW TABLES LIKE 'oledrion_caddy_attributes'
0.001227 SHOW COLUMNS FROM oledrion_products LIKE 'product_price'
0.000399 SELECT FROM config WHERE (conf_modid '0' AND conf_catid '3'ORDER BY conf_order ASC
0.000304 
SELECT FROM group_permission WHERE (gperm_name 'module_admin' AND gperm_modid '1' AND (gperm_groupid '1' OR gperm_groupid '2'))
0.033050 SELECT FROM oledrion_products ORDER BY product_title ASC



--- /smarty_compile

If I clean /xoops_data/caches/smarty_compile/ problem is still here.

--- /smarty_cache

Nothing corrected if I clean this folder.

--- /xoops_cache

I can access creation form if I clean his content
• xoops_adminmenu_XoopsGuiDefault_http...
• xoops_editorlist_http
• ... I'm sorry for this bad test, there was another file but I can't remember his name

(I deleted all files inside, except my xlanguage.php and index.html files)


... I believe users should take care about /xoops_cache folder if they have trouble with creation form.
Still learning CSS and... english

40
maxx3308
Re: Oledrion items' limit
  • 2011/5/18 13:59

  • maxx3308

  • Just popping in

  • Posts: 2

  • Since: 2011/5/18


clean the xoops cache also no help on my website.
Please advise

Login

Username:
Password:

Lost Password? Register now!

Who's Online

82 user(s) are online (56 user(s) are browsing Support Forums)


Members: 0


Guests: 82


more...

Donat-O-Meter

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

Latest GitHub Commits