21
cinleo
Re: Oledrion items' limit
  • 2010/6/9 9:20

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


Firstly thank you all for your answers


InnoDB is active

XOOPS Version - XOOPS 2.4.3
PHP Version - 5.2.13
MySQL Version - 5.0.67-log
Server API Version - apache2handler
OS Version - Linux


safe_mode - Off
register_globals - Off
magic_quotes_gpc - Off
allow_url_fopen - Off
fsockopen - On
allow_call_time_pass_reference - Off
post_max_size - 48M
max_input_time - 10
output_buffering - 20480
max_execution_time - 10
memory_limit - 64M
file_uploads - On
upload_max_filesize - 48M


BDD :
mysql.epmf.eu
Version du serveur: 5.0.67-log
Version du protocole: 10
Serveur: mysql.epmf.eu via TCP / IP
Utilisateur: epmfeusql@imu193.infomaniak.ch
Jeu de Caractères Pour MySQL: UTF-8 Unicode (utf8)
Interclassement Pour la connexion MySQL: phpMyAdmin - 2.11.10
Version du client MySQL: 5.0.84
Extensions PHP utilisées: mysql


the module name has been changed by CATALOG

22
cinleo
Re: Oledrion items' limit
  • 2010/6/10 7:50

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


I realize that adding an article or amendment of article no longer possible. (Error 500)

I tried to re-name the module with "Oledrion" without success

????

23
ghia
Re: Oledrion items' limit
  • 2010/6/10 8:06

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Any messages from debug (look also in the query section)?

24
cinleo
Re: Oledrion items' limit
  • 2010/6/10 8:37

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


Unable to read messages from the "debug" mode because it is a 500 error page that is displayed (HTTP 500 Internal Server Error)

25
ghia
Re: Oledrion items' limit
  • 2010/6/10 8:42

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


That could be a browser setting for displaying friendly error pages. If you disable it, you can sometimes see more with some raw output.

26
cinleo
Re: Oledrion items' limit
  • 2010/6/10 12:38

  • cinleo

  • Just popping in

  • Posts: 10

  • Since: 2010/6/7 6


IE 8, by disabling "simple error message" I get a blank page without any information

27
ghia
Re: Oledrion items' limit
  • 2010/6/10 15:42

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Very tough to find out what your problem is.

- Old try and error debug: look at the URL in the browser.
It will identify the PHP file called, eg /modules/oledrion/all-products.php.
It starts with:
require 'header.php';
$GLOBALS['current_category'] = -1;
$xoopsOption['template_main'] = 'oledrion_allproducts.html';
require_once 
XOOPS_ROOT_PATH.'/header.php';
require_once 
XOOPS_ROOT_PATH.'/class/pagenav.php';
Place before and after some suspected critical lines an echo statement eg with the block above:
echo "start requires";
require 
'header.php';
$GLOBALS['current_category'] = -1;
$xoopsOption['template_main'] = 'oledrion_allproducts.html';
require_once 
XOOPS_ROOT_PATH.'/header.php';
require_once 
XOOPS_ROOT_PATH.'/class/pagenav.php';
echo 
"end requires";
These messages come in the left upper corner of your page. This way you should be able to follow through the code to where it starts going wrong.

-Try once to clone your templates to a new temporary templates set. This may reveal template problems. You don't have to use this set. After cloning you can delete it again.

28
Burning
Re: Oledrion items' limit
  • 2010/6/15 21:24

  • Burning

  • Theme Designer

  • Posts: 1163

  • Since: 2006/8/22


hi'

--- A simple hypothesis.

Blank page appears only when we want to create a new product, the form does not work... sometimes.

If I look into xxx_oledrion_products table, I can see two "strange" things :
• 1 : product_id field contains illogical sequences of numbers (I mean 102 before 17 etc.)
• 2 : cloned products are easily recognizable because their thumb does not have thumb_ prefix (example : 53c666ab1a7c458f.jpg instead of thumb_53c666ab1a7c458f.jpg). This scenario occurs when we keep the same image

The second point is not important, except that most often cloned products seem to have an id "incoherent". Example :

Resized Image


Orange : cloned product / Green : product created from scratch


--- Questions 01

When we use clone feature, code called is :
// ****************************************************************************************************************
    
case 'copy':    // Copier un produit
    // ****************************************************************************************************************
        
xoops_cp_header();
        
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
        if(empty(
$id)) {
            
oledrion_utils::redirect(_AM_OLEDRION_ERROR_1$baseurl5);
        }
        
$opRedirect 'products';
        
$product null;
        
$product $h_oledrion_products->get($id);
        if(
is_object($product)) {
            
$newProduct $h_oledrion_products->cloneProduct($product);
            
$newProductId $newProduct->product_id;
            if(
$newProduct !== false) {
                
oledrion_utils::redirect(_AM_OLEDRION_SAVE_OK$baseurl.'?op='.$opRedirect."&action=edit&id=".$newProductId2);
            } else {
                
oledrion_utils::redirect(_AM_OLEDRION_SAVE_PB$baseurl.'?op='.$opRedirect5);
            }
        }
        break;

Do you see something wrong ?
(oledrion/admin/actions/products.php)


--- Questions 02

Can I clean my products table without danger ? I mean change product ID to obtain a logical sequence of number ...
Still learning CSS and... english

29
ghia
Re: Oledrion items' limit
  • 2010/6/15 21:52

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
• 1 : product_id field contains illogical sequences of numbers (I mean 102 before 17 etc.)
That is normal when you list records of a database (in phpMyAdmin).
You want to click on the header of product_id to have an ordered list.

-1 No, and there is probably nothing wrong. I think you are on the wrong track here. See the ordered list.

-2 See the ordered list (731 is probably some earlier deleted product)

30
Burning
Re: Oledrion items' limit
  • 2010/6/15 22:24

  • Burning

  • Theme Designer

  • Posts: 1163

  • Since: 2006/8/22


hi'

Thanks Ghia for response.

So, wrong hypothesis.

I thought the blank page was caused by the cloning of the product. Specifically:
• that cloning causes inconsistent IDs
• when the creating form called an existing ID, this caused a blank page



[off-topic]
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.
[/off-topic]


Another point :
- XOOPS 2.4.3
- Oledrion 2.31
- No wisywig editor (DHTML area used)
- PHP Version : 5.2.13
- MySQL Version : 5.0.67-log
Still learning CSS and... english

Login

Who's Online

219 user(s) are online (143 user(s) are browsing Support Forums)


Members: 0


Guests: 219


more...

Donat-O-Meter

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

Latest GitHub Commits