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: Critical Error Upon Installing Shopping Cart  (Read 9224 times)

0 Members and 1 Guest are viewing this topic.

derangedtaco

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Critical Error Upon Installing Shopping Cart
« on: July 09, 2009, 12:10:00 am »

Upon installation of the plugin "Shopping Cart" (http://forum.coppermine-gallery.net/index.php/topic,57206.html), I encounter a critical error.

Shouldn't matter, but just FYI: My coppermine install is bridged with phpbb3. I have also performed a core hack in order to integrate coppermine into my joomla install.

Here is my debug output:
Code: [Select]
Critical error

There was an error while processing a database query.

While executing query "SELECT * FROM cpg14x_shop_config ORDER BY priority ASC" on 0

mySQL error:

Code: [Select]
File: /home/deranged/public_html/gallery/include/functions.inc.php - Line: 250 
Code: [Select]
USER:
------------------
Array
(
    [ID] => 5afae37c6adf11c2ab1c02da4ec2a389
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

)

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

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

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg14x_bridge (0s)
    [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) (0s)
    [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_shop_config ORDER BY priority ASC (0s)
    [7] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
)

==========================
GET :
------------------
Array
(
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.9 - OK
------------------
mySQL version: 4.1.22-standard
------------------
Coppermine version: 1.4.24(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 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
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 4
Client API version 4.1.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
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 | show_source, system, passthru, popen, proc_open | show_source, system, passthru, popen, proc_open
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 60000 | 36000
max_input_time | 60000 | 60
upload_max_filesize | 100M | 2M
post_max_size | 100M | 8M
==========================
Page generated in 0.238 seconds - 8 queries in 0 seconds - Album set : ; Meta set: ;

Any help would be greatly appreciated.
Logged

derangedtaco

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Critical Error Upon Installing Shopping Cart
« Reply #1 on: July 09, 2009, 12:13:09 am »

Sorry for the double post, but I am unable to edit my previous message.

I just looked for the table cpg14x_shop_config in coppermine's SQL db. It's not there.

So, the plugin encounters the problem while trying to create the new table. What can be done about this?
Logged

Nibbler

  • Guest
Re: Critical Error Upon Installing Shopping Cart
« Reply #2 on: July 09, 2009, 12:18:35 am »

Bug in the plugin. Edit codebase.php, find

Code: [Select]
if (mysql_query($q)) {

Change to

Code: [Select]
if (cpg_db_query($q)) {

Then install it again.
Logged

derangedtaco

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Critical Error Upon Installing Shopping Cart
« Reply #3 on: July 10, 2009, 04:43:26 am »

Bug in the plugin. Edit codebase.php, find

Code: [Select]
if (mysql_query($q)) {

Change to

Code: [Select]
if (cpg_db_query($q)) {

Then install it again.
Unfortunately that didn't do the trick.

After making the modification to codebase.php and reinstalling the plugin, I still get:
Code: [Select]
While executing query "SELECT * FROM cpg14x_shop_config ORDER BY priority ASC" on 0

mySQL error:
Code: [Select]
USER:
------------------
Array
(
    [ID] => 5afae37c6adf11c2ab1c02da4ec2a389
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

)

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

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

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg14x_bridge (0s)
    [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) (0s)
    [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_shop_config ORDER BY priority ASC (0s)
    [7] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
)

==========================
GET :
------------------
Array
(
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.9 - OK
------------------
mySQL version: 4.1.22-standard
------------------
Coppermine version: 1.4.24(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 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
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 4
Client API version 4.1.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
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 | show_source, system, passthru, popen, proc_open | show_source, system, passthru, popen, proc_open
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 60000 | 36000
max_input_time | 60000 | 60
upload_max_filesize | 100M | 2M
post_max_size | 100M | 8M
==========================
Page generated in 0.233 seconds - 8 queries in 0 seconds - Album set : ; Meta set: ;
Logged

derangedtaco

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Critical Error Upon Installing Shopping Cart
« Reply #4 on: July 12, 2009, 02:32:26 am »

Any help, please?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Critical Error Upon Installing Shopping Cart
« Reply #5 on: July 12, 2009, 11:45:30 am »

Did you click the go button after the installation shows the 'todo mysql queries'?

derangedtaco

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Critical Error Upon Installing Shopping Cart
« Reply #6 on: July 12, 2009, 08:53:25 pm »

Did you click the go button after the installation shows the 'todo mysql queries'?
No, it didn't even get to that point.

This time I encountered the error upon upload of the .zip
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Critical Error Upon Installing Shopping Cart
« Reply #7 on: July 12, 2009, 10:49:53 pm »

Don't upload the zip, but extract on your client and then FTP-upload the plugin's folder. Option 2 in the docs
Logged

derangedtaco

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Critical Error Upon Installing Shopping Cart
« Reply #8 on: July 12, 2009, 11:10:05 pm »

Don't upload the zip, but extract on your client and then FTP-upload the plugin's folder. Option 2 in the docs
When I first tried to do that, it gave me the same error as when I tried to install it via option 1. So I assumed that coppermine was keeping some record of that plugin, thinking that it was still installed or something.

So I renamed the folder. Then I was able to navigate to the plugins page and (re)install the recently renamed plugin. I clicked "Go" on the "Performing Database Updates" page, and things were looking good, but then the following error was returned:
Code: [Select]
While executing query "insert into cpg14x_plugins (name, path,priority)  values ("Photo Shop","photo_shop1",5);" on 0

mySQL error:
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Critical Error Upon Installing Shopping Cart
« Reply #9 on: July 12, 2009, 11:27:19 pm »

renamed it won't work... so remove the netry from the db with a toll like phpmyadmin
table CPG_plugins

derangedtaco

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 46
Re: Critical Error Upon Installing Shopping Cart
« Reply #10 on: July 12, 2009, 11:40:26 pm »

renamed it won't work... so remove the netry from the db with a toll like phpmyadmin
table CPG_plugins
Sweet! That did the trick.

However, now I am experiencing what is likely a bridge problem.
When I try to access the plugin's options page:
Code: [Select]
While executing query "SELECT s.*, u.username, u.email  FROM cpg14x_shop AS s LEFT JOIN `deranged_jo152`.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:
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 19 queries.