Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Shopping Cart: Critical Error in Shop admin  (Read 3680 times)

0 Members and 1 Guest are viewing this topic.

PerformanceImagery

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Shopping Cart: Critical Error in Shop admin
« on: January 03, 2008, 02:28:53 am »

I think this one is going to be had to track down...

When I am logged in to my Coppermine gallery as the admin and click on the Shop admin button, it returns a Critical error.  See attached image please.  I'm sure it is cause be one of the modifications I made some place.  Is the admin section contained in one place or file I should start looking in?

Thanks for any directions.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping Cart: Critical Error in Shop admin
« Reply #1 on: January 03, 2008, 07:26:45 am »

enable debug mode and post the actual error message

PerformanceImagery

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: Shopping Cart: Critical Error in Shop admin
« Reply #2 on: January 03, 2008, 07:57:18 am »

This is what it gives me...

Code: [Select]
While executing query "SELECT s.*, u.username, u.email  FROM cpg14x_shop AS s LEFT JOIN `piphoto_install_1195711693`.jos_users as u ON u.id = s.uid WHERE aktive=0 AND cd=1 ORDER BY oid DESC LIMIT 0, 25" on

mySQL error:

And....

Code: [Select]
USER:
------------------
Array
(
    [ID] => a3f24b42d2a39dfa2e8c720ee6bb5b0a
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 173
            [1] => 179
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 62
    [user_name] => mobo
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 0
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0.001s)
    [1] => select * from cpg14x_plugins order by priority asc; (0.006s)
    [2] => SELECT * FROM cpg14x_bridge (0.008s)
    [3] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0.001s)
    [4] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [5] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 62 (0s)
    [6] => SELECT * FROM cpg14x_final_extract_config (0s)
    [7] => SELECT * FROM cpg14x_shop_config ORDER BY 'priority' (0s)
    [8] => DELETE FROM cpg14x_banned WHERE expiry < '2008-01-02 23:54:01' (0s)
    [9] => SELECT * FROM cpg14x_banned WHERE (ip_addr='12.109.151.100' OR ip_addr='0.0.0.0' OR user_id=62) AND brute_force=0 (0s)
    [10] => SELECT count(DISTINCT oid) FROM cpg14x_shop WHERE aktive='1' (0.147s)
    [11] => SELECT count(DISTINCT oid) FROM cpg14x_shop WHERE aktive='0' (0.01s)
    [12] => SELECT s.*, u.username, u.email  FROM cpg14x_shop AS s LEFT JOIN `piphoto_install_1195711693`.jos_users as u ON u.id = s.uid WHERE aktive=0 AND cd=1 ORDER BY oid DESC LIMIT 0, 25 (0.001s)
    [13] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0.022s)
)

==========================
GET :
------------------
Array
(
    [file] => photo_shop/photo_shop_admin
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.4.7 - OK
------------------
mySQL version: 5.0.45-log
------------------
Coppermine version: 1.4.14(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 2
Client API version 4.1.11
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.2
Linked Version 1.2.2
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/local/lib/php-4.4.7/lib/php | .:/usr/local/lib/php-4.4.7/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | wwwuser@cgi.yourhostingaccount.com | wwwuser@cgi.yourhostingaccount.com
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
SMTP | mail.yourhostingaccount.com | mail.yourhostingaccount.com
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 10M | 10M
post_max_size | 11M | 11M
==========================
Page generated in 0.516 seconds - 14 queries in 0.196 seconds - Album set : ; Meta set: ;
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping Cart: Critical Error in Shop admin
« Reply #3 on: January 04, 2008, 01:42:25 pm »

looks like a problem with the joomla bridge ... prolly selecting the wrong db/ table. You could try to hardcode that into the shop admin queries. But as you already know, I do not have joomla installed and do know nothing about it, therefore ... not much more I can advise.
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.