OK this just started happening today... no clue why.
I install the forums like usual, go through the config and set stuff up. Everything is still fine.. then I go and add categories and albums... then sudnelly the Admin Tools and Upload approval areas get...
Quote
There was an error while processing a database query
I have uninstalled/reinstalled 5 times and it happens every time! I totally wiped the DB and remade it.. and it still happens! This didn't happen yesterday... but it started today!
Any suggestions? It looks like everything is working aside from Admin Tools and Upload approval. BTW I already tryed running update.php... it gives OK to a few things every time.. doen't fix a thing. I also tryed to fix my DB in Cpanel... said all was OK.
what version of coppermine are you using? Enable debug_mode in coppermuine config to see what query actually fails. Post a link to your site.
GauGau
1.3.1
www.spudfiles.com/gallery/
I wanted to note that even with debug mode off.. I see this at the bottom of the config page...
Quote
ig_data); echo << EOT; endtable(); pagefooter(); ob_end_flush(); ?>
I enabled debug mode for everyone... I am looking it...
When I go to Admin Tools I get at the top...
Quote
While executing query "SELECT aid, category, IF(user_name IS NOT NULL, CONCAT('(', user_name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg131_albums AS a LEFT JOIN cpg131_users AS u ON category = (10000 + user_id) ORDER BY category, title" on 0
mySQL error: Got error 28 from table handler
And I get the same (or very similar) when I go to Upload Approval.
Thanks :)
BTW... it happened in...
Quote
File: /home/pcguy/public_html/gallery/include/functions.inc.php - Line: 105
And I tryed replaceing the functions.inc.php from the original download and it didn't fix it :(
Annnd... Just in case you need it...
Quote
USER:
------------------
Array
(
[ID] => 662fb46f716b60d2e201997562ce7235
[am] => 1
[liv] => Array
(
- => 1
[1] => 2
)
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_group] => 1
[user_active] => YES
[user_name] => PCGUY
[user_password] => ********
[user_lastvisit] => 2004-08-17 00:18:30
[user_regdate] => 2004-08-17 00:00:06
[user_group_list] =>
[user_email] =>
[user_website] =>
[user_location] =>
[user_interests] =>
[user_occupation] =>
[user_actkey] =>
[user_favpics] =>
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[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] => 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] => 3
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[groups] => Array
(
[1] => 1
)
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg131_filetypes;
[1] => SELECT * FROM cpg131_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'ed6e621a2a8acee420864ae6f4d2eb06'
[2] => 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 cpg131_usergroups WHERE group_id in (1)
[3] => SELECT group_name FROM cpg131_usergroups WHERE group_id= 1
[4] => DELETE FROM cpg131_banned WHERE expiry < 1092721057
[5] => SELECT * FROM cpg131_banned WHERE ip_addr='24.171.117.167' OR ip_addr='24.171.117.167' OR user_id=1
[6] => SELECT aid, category, IF(user_name IS NOT NULL, CONCAT('(', user_name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg131_albums AS a LEFT JOIN cpg131_users AS u ON category = (10000 + user_id) ORDER BY category, title
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.8 - OK
------------------
mySQL version: 4.0.20-standard
------------------
Coppermine version: 1.3.1
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.23 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /var/tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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/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 | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.497 seconds - 7 queries in 0.003 seconds - Album set :
Quote from: PCGUY112887 on August 17, 2004, 07:31:10 AM
I wanted to note that even with debug mode off.. I see this at the bottom of the config page...
Quoteig_data); echo << EOT; endtable(); pagefooter(); ob_end_flush(); ?>
This usually is an indication that one or more files are corrupt. Re-upload all coppermine files (make sure to use the proper ftp mod), overwriting all files that exist on your server.
GauGau
This is what I did when I said I tryed re-installing it 5 times... I've tryed redownloading it too and uploading.. no luck.
Please try what I suggested here: http://forum.coppermine-gallery.net/index.php?topic=8967.msg40182#msg40182
GauGau
Well I didn't have to. I got really pissed at it... wiped every damn thing of coppermine I had on my computer and server, then redid everything.. and NOW it's fine... ???
O well, at least it's working now! Thanks :)