11
ghia
Re: Oledrion items' limit
  • 2010/6/7 8:50

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


This is not a XOOPS message, but from phpMyAdmin.
It may indicate a problem in your database. Try to do a repair of your database tables.

12
cinleo
Re: Oledrion items' limit
  • 2010/6/7 15:07

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


indeed, it is an error message of the database. The repair did not work. if somebody who controls the database, a solution must be possible.

13
ghia
Re: Oledrion items' limit
  • 2010/6/7 22:29

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


In which page / URL of phpMyAdmin do you get this error?
Did you try to repair all tables one by one?
Did you open a ticket with your hoster for this problem?

14
cinleo
Re: Oledrion items' limit
  • 2010/6/8 7:15

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


Here's the page or the error is indicated :
http://imu193.infomaniak.ch/MySQLAdmin/index.php?db=epmfeu2&token=e78a9d03a8f48c427d427addc72f4db5

I did the repair without success.

Je vais demandé à l'hébergeur si l'erreur peut venir de chez eux

thank you your answers

15
cinleo
Re: Oledrion items' limit
  • 2010/6/8 14:45

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


Voici la réponse de l'hébergeur:

Le tableau n'est pas marqué comme défections xc5c_oledrion_products

mysql> xc5c_oledrion_products table de réparation;
+--------------------------------+--------+------- ---+----------+
| | Table Op | Msg_type | Msg_text |
+--------------------------------+--------+------- ---+----------+
Epmfeu2.xc5c_oledrion_products | | réparations | statut | | OK
+--------------------------------+--------+------- ---+----------+
1 row in set (5.70 sec)

Le message porté à la consultation via phpmyadmin c'est parce que la base contient deux tables MyISAM et InnoDB format, dans lequel phpmyadmin cas rechercher la présence de clé étrangère tables MyISAM aussi, et s'il n'en existe pas, le code génère un avertissement. Le message peut paraître surprenant, mais n'a pas eu à faire avec votre problème.

Votre problème de l'insertion du nouvel article pourrait être liée à une préoccupation de l'insuffisance de type clé primaire (par exemple tinyint) pour lequel une valeur de l'auto-incrémentation peut être trop grande. C'est la seule supposition. Nous vous conseillons d'abord de vérifier que vous pouvez faire des applications comme l'insérer dans votre table.

16
cinleo
Re: Oledrion items' limit
  • 2010/6/8 15:04

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


inserted in the article directly given base functions

17
Peekay
Re: Oledrion items' limit
  • 2010/6/8 16:27

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


I believe this module was developed by Hervet, so I doubt if any incrementing value data type will be incorrect (e.g. accidentally using TINYINT which would stop at record 127, or 255).

You should be able to mix InnoDB and MyISAM tables in the same application, but InnoDB support needs to be enabled on the server.

Your host seems to think it is, but you can check yourself:

* Open phpMyAdmin.
* Click on the 'Storage Engines' link on the main screen.
* If InnoDB is enabled it will be highlighted in blue.
A thread is for life. Not just for Christmas.

18
ghia
Re: Oledrion items' limit
  • 2010/6/8 19:38

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


PHP and MySQL version?

19
Burning
Re: Oledrion items' limit
  • 2010/6/8 20:01

  • Burning

  • Theme Designer

  • Posts: 1163

  • Since: 2006/8/22


hi'

[off-topic ?]
... may be a bug with clone product function ? Why I suspect this point ?
• not directly developed by Hervet if I well remember
• I use Oledrion on many websites, and never have such bug (local and production environments)
• I never used clone feature
[/off-topic ?]
Still learning CSS and... english

20
Peekay
Re: Oledrion items' limit
  • 2010/6/8 23:09

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


Yes, I agree with Burning - assume you have not cloned the module or renamed it?.

You are running PHP 5.2.13 and MySQL 5.0.84.
A thread is for life. Not just for Christmas.

Login

Who's Online

171 user(s) are online (116 user(s) are browsing Support Forums)


Members: 0


Guests: 171


more...

Donat-O-Meter

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

Latest GitHub Commits