- April 27, 2024, 12:21:40 pm
- Welcome, Guest
News:
cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]
Search results for: mySQL error Unknown column user_profile1 in field list
...... new to all this so I'm not 100% sure what this error message means when I try to install this. Can ............ help? Unknown column 'p.owner_name' in 'field list' SELECT p. ............ pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS ............ AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS ............ .keyword as aKeyword FROM cpg_pictures AS p LEFT JOIN cpg_users AS u ON p.owner_id = u.user_id LEFT ............ cpg_albums AS a ON p.aid = a.aid LEFT JOIN cpg_categories AS c ON a.category = c.cid WHERE 1 ............ = "")) ORDER BY p.ctime DESC LIMIT 0,4 Warning: mysql_fetch_assoc(): supplied argument is not a ............ MySQL result resource in /home/content/69/6415869/html/ ............ /cpmfetch/cpmfetch_dao.php on line 1260 Warning: mysql_free_result(): supplied ............ is not a valid MySQL result resource in /home/content/69/6415869/html/ ............ /cpmfetch/cpmfetch_dao.php on line 1264 Thanks ......
32
cpg1.5 permissions / Re: Weird user groups problem: Anonymous reverts back to Guest
« by decoy4000 on August 21, 2010, 03:37:47 pm »...... support on this great product. My Dad's been using it on V1.3 for over 5 years now. I am in the ............ of setting up a new instance on another server. After ............ long reading and many retry's I managed to get 1.5 up and ............ with original data. However I have this funny error, I can ............ view thumbnail, intermediate, and full-size images when logged in as ............ registered user. As Anonymous I get this error when trying to access a full-size image: While ............ .140', mtime = CURRENT_TIMESTAMP WHERE pid = 413' in include/functions.inc.php on line 2719 mySQL ............ : Unknown column 'lasthit_ip' in 'field list' Under the ............ settings I have the three standard groups. Administrator, ............ "Guest". "Guest" has a red X next to it recommending I change the group name to Anonymous. http:// ............ be reverted back to "Guest" I Imported the original group table from the previous db and after ............ back to Guest. Please let me know what other information I can share to help resolve this problem. ......
33
cpg1.5 upgrading / Upgrading Current Gallery to Latest Coppermine Isn't Working!
« by torgasm on August 23, 2010, 08:15:48 pm »...... saw quite a few people having issues w/ Fatal Errors but I need help ............ with this. I think I saw someone talking about this somewhere, but ............ 't understand it at all. What exactly does this error mean, and what do I go about doing to fix it? ............ ://tokiopix.com Fatal Error : While executing query 'SELECT MAX(group_quota) ............ AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg_usergroups WHERE group_id in (1)' in bridge/udb_base.inc.php on line 321 ............ error: Unknown column 'access_level' in 'field list' ( ............ can't see anything on my site, except I see my theme comes up still ......
34
cpg1.5 upgrading / "Fatal Error" after upgrade from 1.4.24 to 1.5.10
« by profili on January 01, 2011, 11:30:52 pm »...... , I have followed the instuctions of the upgrade process in one of my ............ , but it seems that something is going wrong and this gallery wont upgrade. ............ i got a simple error message and a blank page. Have searched around ............ I think I have the same problem as this here http:// ............ .coppermine-gallery.net/index.php/topic,65521.0.html I have ............ the debug mode on following this guide here http://documentation.coppermine- ............ .net/en/errors.htm#errors_fatal And here we are: Code: [ ............ ] While executing query 'SELECT MAX(group_quota) AS disk_max, MIN( ............ ) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX( ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg148_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 323 ............ error: Unknown column 'access_level' in 'field list' ............ to do with these codes, I don't understand anything there. Please someone help me how to fix these ......
...... from version 1.4.1927 to version 1.5X2 and get an error, I do not now how to proceed. http://www. ............ .nl/beeldbank1/index.php While executing query 'SELECT MAX( ............ ) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg146_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 321 ............ error: Unknown column 'access_level' in 'field list' ......
36
cpg1.4.x Español (Spanish) / Re: Ayuda !! ( include/functions.inc.php - Línea: 250 )
« by Fercho on September 14, 2010, 12:26:59 am »...... por dormilon. Acá esta el enlace http://www.infiernomurguero.com.ar/galeria/ Subi la ultima ............ y me sigue tirando error While executing query "INSERT INTO ............ ', '186.18.172.116', '186.18.172.116', '0')" on 0 mySQL error: Unknown column 'owner_name' in 'field list' ............ quedaron de una versión desactualizada de Coppermine: 0 Versiones de archivos desactualizadas: ......
37
cpg1.5.x Español (Spanish) / ¿Sirve el Cpmfetch para cpg1.5.x?
« by carolusabe on July 13, 2010, 06:36:14 pm »...... . He encontrado problemas parecidos y lo he intentado solucionar igual ,pero no da resultado. ............ muy poco me eliminaron mi galería y como tenía que hacer una nueva ( ............ algunos problemas con el cpanel), me decidí a instalar la nueva cpg1.5.x , y me encanta la verdad ............ nuevas, todo me va perfectamente y no he tenido ningun problema, solo que instalé el Cpmfetch (muchas ............ y de formas diferentes) y me sale esto en el install.php: Quote "Unknown column 'p.owner_name' ............ 'field list' SELECT p.filepath AS pFilepath, p.filename ............ pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS ............ AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS ............ as aKeyword FROM cpg15x_pictures AS p LEFT JOIN cpg15x_users AS u ON p.owner_id = u.user_id LEFT ............ cpg15x_albums AS a ON p.aid = a.aid LEFT JOIN cpg15x_categories AS c ON a.category = c.cid ............ = "")) ORDER BY p.ctime DESC LIMIT 0,4 Warning: mysql_fetch_assoc(): supplied argument is not a ............ MySQL result resource in /home/jdeppco/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1349 Warning: mysql_free_result(): supplied ............ is not a valid MySQL result resource in /home/jdeppco/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1353" Os dejo una captura: (https://forum. ............ %3A%2F%2Fimg441.imageshack.us%2Fimg441%2F4024%2Finstallphp.jpg&hash= ............ esta: http://jdepp.com/galeria/ Y como lo he desinstalado e instalado muchas veces y siempre me pone ............ mismo error, he pensado que alomejor en esta version del Cpg ......
...... the suggestion of this forum http://forum.coppermine-gallery.net/index.php/topic,65792.0.html and I ............ be lost on the process. Now I am stuck with this error While executing query 'SELECT title, r. ............ , r.owner FROM cpg_categories AS c INNER JOIN cpg_albums AS r ON r.category = c.cid ............ BETWEEN 0 + 1 AND 0 + 2 ORDER BY r.pos, r.aid' in index.php on line 378 mySQL error: Unknown ............ 'r.owner' in 'field list' Please help. Thank you. ......
...... know I am supposed to put a link to the forum - however it is not a public forum ............ I am not able to put a link. I have 5 sites - and I upgraded 4 of them no ............ . The 5th is not upgrading - it is a large site with many images. I ............ files except the album directory and the config.inc.php. I repaired the database. I have no ............ installed. I uploaded the 1.5 files and tried the ............ a few times. This is what happens: 1. Running update.php it asks me for my Coopermine or MySQL ............ and password. 2. The update runs for about 10 minutes and then I get a white page on firefox and a ............ I try the upgrade I go to the site and get the info below. 4. If I delete the 1.5 files and upload ............ 1.4 files the site works with no install or upgrade. While executing query 'SELECT ............ (group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg131_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 321 ............ error: Unknown column 'access_level' in 'field list' ......
...... gallery hates me: Critical error There was an error while processing a database ............ . While executing query 'SELECT user_name, COUNT(*) as ............ FROM `thefanta_attic`.smf8_members AS u INNER JOIN cpg14x_comments AS c ON c.author_id = u. ............ GROUP BY user_name HAVING num_comments >= 10 ORDER BY num_comments DESC' ............ top-comments.php on line 7 mySQL error: Unknown column 'user_name' in ' ............ list' File: /home/thefanta/public_html/attic/cpg/ ............ /functions.inc.php - Line: 272 ......
41
cpg1.5.x Deutsch (German) / Fatal Error nach Upgrade (1.4.x -> 1.5.6)
« by MarKon on August 03, 2010, 01:47:17 am »...... ://www.drk-badsalzuflen.de/Galerie/ Nachdem ich ein Upgrade, wie in der Doku beschrieben, durchgefü ............ habe, kommt folgender Fatal Error: Code: [Select] While executing query 'SELECT ............ (group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg14x_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 321 ............ error: Unknown column 'access_level' in 'field list' ............ phpMyAdmin habe ich mir die Tabellen angesehen und in der ' ............ Feld sollte eigentlich durch die update.php hinzugefügt werden. Auch einiges andere, was update. ............ nun schon mehrfach die update.php gestartet doch hinter jeder Zeile steht 'Already Done'. Wie kann ich ............ damit es die Änderungen durchführt? Die Lösungen in den Threads mit ähnliche Problem hier im Forum ......
42
cpg1.5.x Deutsch (German) / Re: Bridge zu phpBB 3.1.2
« by Steve1400 on December 17, 2014, 11:34:37 am »...... executing query 'SELECT *, username AS user_name, ............ `DB*******`.phpbb_users WHERE user_id = '2'' in bridge/udb_base.inc.php on line 414 mySQL error: ............ column 'user_from' in 'field list' Das Problem ist, in ............ 3.1.2 befindet sich "user_from" nicht mehr in der Tabelle " ............ . Bei phpBB 3.0.12 war das noch so... Bei Coppermine 1.5.34 hat sich gegenüber Version 1.5.30 in der ............ nichts geändert (btw. ich sehe keine Änderungen wenn ich die Dateien vergleiche). Ich ............ . 1.5.34 auch nicht korrekt funktionieren wird. Ein Update von Coppermine werde ich demnächst aber ......
43
cpg1.5.x Español (Spanish) / Re: Error crítico (registro)
« by marioo on January 26, 2012, 09:03:29 am »...... é está pasando. Saludos, eso he hecho: Quote Error crítico Se produjo un error al procesar una ............ de base de datos. While executing query 'SELECT user_active, user_email, ............ , user_name, user_pass, user_profile1, user_profile2, user_profile3, user_profile6 FROM ............ = '57bc9bdd8b1f6c2b4871365a9a7ebb31' LIMIT 1' in register.php on line 710 mySQL error: Unknown ............ 'user_pass' in 'field list' Fichero: /home/a4336203/ ............ /galeria/include/functions.inc.php - Linea: 270 ......
...... :01 pm Hello Gerg, I did like you say. But the error measage appeared: #1054 - Unknown column ' ............ ' in 'field list' (pl. look at the picture) Thank you, ............ and 2) The ` is used around database, table, and field names, and ' or " is used around values. The ` ............ is optional as long as no special characters or MySQL keywords. PhpMyAdmin adds them when constructing ......
...... . I have this error Code: [Select] Unknown column 'p.owner_name' in ' ............ list' SELECT p.filepath AS pFilepath, p.filename AS ............ pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS ............ AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS ............ as aKeyword FROM cpg14x_pictures AS p LEFT JOIN cpg14x_users AS u ON p.owner_id = u.user_id LEFT ............ cpg14x_albums AS a ON p.aid = a.aid LEFT JOIN cpg14x_categories AS c ON a.category = c.cid ............ = "")) ORDER BY p.ctime DESC LIMIT 0,4 Warning: mysql_fetch_assoc(): supplied argument is not a ............ MySQL result resource in /home/savtreyn/emmy-rossum. ............ /gallery/cpmfetch/cpmfetch_dao.php on line 1349 Warning: mysql_free_result(): supplied ............ is not a valid MySQL result resource in /home/savtreyn/emmy-rossum. ............ /gallery/cpmfetch/cpmfetch_dao.php on line 1353 coppermain gallery version Coppermine Photo ............ 1.4.25 (stable) cpmFetch version 2.1.1 also installed stramm_mod1.4.24.bridge thank you for any ......
46
cpg1.5.x Français (French) / Re: Index galerie - fatal error
« by LianN on April 21, 2012, 01:10:15 pm »...... n'ai pas su le faire. J'ai suivit la doc coppermine pour activer le mode de debogage pour afficher ............ de la galerie. Ca me dit ça: Quote While executing query 'SELECT MAX(group_quota) AS disk_max, MIN( ............ ) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX( ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg14x_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 323 ............ error: Unknown column 'access_level' in 'field list' ......
47
cpg1.4 upgrading / [Solved]: "Error while processing a database query" after upgrading from 1.3.2 to 1.4.25
« by Passionate on December 21, 2009, 03:48:18 pm »...... I really hope someone can help me. I've been googling and looking through the forums but can't find an ............ to upgrade from 1.3.2 to 1.4.25 and it all went fine, I checked all the file versions and the config ............ fine. BUT, when I want to look at a gallery, I get ............ error: Quote There was an error while processing a ............ query. While executing query "SELECT pid, filepath, filename, ............ ='853' ) ) ORDER BY title DESC LIMIT 0 ,20" on 0 mySQL error: Unknown column 'owner_name' in 'field list' ............ File: /home/lindah/public_html/juliaimages/include/functions.inc. ............ - Line: 250 URL: http://www.aboutjulia.com/ ............ .php?album=853 And also, this is the debug info: Quote USER: ------------------ Array ( [ ............ - Array ( [user_id] => 1 [user_name] => admin [groups] => Array ( => 1 ............ ) [disk_max] => 0 [disk_min] => 0 [can_rate_pictures] => 1 [ ............ ] => 1 [ufc_max] => 3 [ufc_min] => 3 [custom_user_upload] => 0 [ ............ ] => 1 [can_create_albums] => 1 [has_admin_access] => 1 [pub_upl_need_approval] => 0 ............ ] => 0 [group_name] => Administrators [upload_form_config] => 3 [ ............ ; (0s) [1] => select * from cpg132_plugins order by priority asc; (0s) [2] => delete ............ `lindah_photos`.cpg132_sessions where time<1261403070 ............ remember=0; (0s) [3] => delete from `lindah_photos`.cpg132_sessions where time<1260197070; ............ (0s) [4] => select user_id from `lindah_photos`.cpg132_sessions where session_id = ' ............ user_id as id, user_password as password from `lindah_photos`.cpg132_users where user_id=1 (0s) [ ............ AS password, u.user_group+100 AS group_id FROM `lindah_photos`.cpg132_users AS u INNER JOIN ` ............ u.user_id='1' (0s) [7] => SELECT user_group_list FROM `lindah_photos`.cpg132_users AS u WHERE ............ ='1' and user_group_list <> ''; (0s) [8] => SELECT MAX(group_quota) as ............ , MIN(group_quota) as disk_min, MAX(can_rate_pictures) ............ , MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX( ............ ) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN( ............ ) as pub_upl_need_approval, MIN( priv_upl_need_approval) as ............ FROM cpg132_usergroups WHERE group_id in (1) (0s) [9] => SELECT group_name FROM ............ WHERE group_id= 1 (0s) [10] => update `lindah_photos`.cpg132_sessions set time='1261406670' ............ , title, aid, keyword, description, alb_password_hint FROM cpg132_albums WHERE aid='853' (0s) [15] ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 5.2.11 - OK -- ............ ---------------- mySQL version: 5.1.30 ------------------ Coppermine ............ (2.0.34 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support: GIF Read ............ Support: ========================== Module: mysql ------------------ MySQL Supportenabled Active ............ Links 0 Active Links 1 Client API version 5.1.30 ............ external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE - ............ /usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient ............ compress.zlib:// Stream Filter support zlib.inflate, zlib.deflate Compiled Version 1.2.3 ............ | no value safe_mode_gid | Off | Off safe_mode_include_dir | no value | no value safe_mode_exec_dir ............ | dl | dl file_uploads | On | On include_path | .:/usr/lib/php:/usr/local/lib/php | .: ............ | no value | no value sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i SMTP | ............ | Master Value max_execution_time | 30 | 30 max_input_time | 60 | 60 upload_max_filesize | 64M | 64M ............ | 64M ========================== Page generated in 0.038 seconds - 21 queries in 0 seconds - Album ......
48
cpg1.4 miscellaneous / There was an error while processing a database query
« by Acen8s on June 07, 2010, 01:38:05 pm »...... 've been trying to solve this issue for several days now and ............ . My <a herf="http://www.pro-dezign.com/coppermine/index.php">Gallery</a> contains nudity so be ............ before visiting. My web host informs me that it's not a server ............ and they can not help. The error message is ( mySQL error: Unknown column ' ............ ' in 'field list' ) I did a table repair in phpmyadmin ............ help. There is also a message that say's ( coppermine/include/functions.inc.php - Line: 250 ) so I ............ that didn't solve the issue either. I am not posting the debug output until it's requested. I would ......
49
cpg1.4 miscellaneous / Re: Database Error - Unknown column???
« by psylocke on January 14, 2010, 12:35:14 am »...... even after the move. How can I add this missing field? Quote While executing query "INSERT ............ ', '60622', '445', '295', '1263425171', '1', 'admin','', '', '', 'YES', '', '', '', '', '', '', '0')" ............ 0 mySQL error: Unknown column 'owner_name' in 'field list' ......
...... . I am upgrading to 1.5.22, just typed it wrong. I have enabled ............ mode and am now getting the following: "While executing query 'SELECT ............ (group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg1416_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 323 ............ error: Unknown column 'access_level' in 'field list'" ......
...... While executing query 'SELECT MAX(group_quota) AS disk_max, MIN( ............ ) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX( ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval, ............ FROM cpg_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 321 ............ error: Unknown column 'access_level' in 'field list' ......
52
cpg1.4 modpack by Stramm / [Solved]: Unknown column in field list
« by sophie on March 07, 2010, 08:15:17 pm »...... debug mode when Fatal error: came up Here is what it says: While executing ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ AS group_id FROM `soproy5_copp12`.cpg_users AS u INNER JOIN `soproy5_copp12`.cpg_usergroups AS g ON u. ............ .group_id WHERE u.user_id='1'" on Resource id #6 mySQL error: Unknown column 'u.avatar_url' in 'field ......
...... get this error when editing a users privledges, any ideas? ............ executing query "UPDATE cpg11d_users SET user_name = ' ............ ', user_email = 'info@batcars.co.uk', user_active = 'YES', ............ = '2', user_location = '', user_interests = '', user_website = '', ............ user_lang = '1' WHERE user_id = '529'" on 0 mySQL error: Unknown column 'user_lang' in 'field list' ......
54
cpg1.4 upload / Changing from ImageMagick to GD 2.x
« by greggles1975 on April 11, 2007, 11:19:31 am »...... , my hosting service doesn't appear to support ImageMagick ............ . So I am going to use GD 2.x for the image manipulation when ............ pictures. I'm getting an error when uploading a picture which look ............ it's related to a missing database column. The picture is modifed, with ............ created etc, but the pictures are left in the /albums/userpics and not moved into the / ............ some DB changes I need to make to accomodate using GD 2.x, and if so will it affect images which ............ been uploaded with ImageMagick? Here is the SQL error message, followed by the debug info: While ............ query "INSERT INTO cpg_pictures (aid, filepath, filename, ............ , '480009', '1360', '2048', '1176280572', '1', 'Admin','', '', '', 'YES', '', '', '', '', '125.239.206. ............ ', '125.239.206.110', '0')" on 0 mySQL error: Unknown column 'position' in 'field list' ............ ******************************Debug info************************************************ ............ - Array ( [user_id] => 1 [user_name] => Admin [groups] => Array ( => 1 ............ ) [disk_max] => 0 [disk_min] => 0 [can_rate_pictures] => 1 [ ............ ] => 1 [ufc_max] => 0 [ufc_min] => 0 [custom_user_upload] => 0 [ ............ ] => 1 [can_create_albums] => 1 [has_admin_access] => 1 [pub_upl_need_approval] => 0 ............ ] => 0 [group_name] => Administrators [upload_form_config] => 0 [ ............ AS group_id FROM `karumba_copp1`.cpg_users AS u INNER JOIN `karumba_copp1`.cpg_usergroups AS g ON u. ............ u.user_id='1' (0s) [6] => SELECT user_group_list FROM `karumba_copp1`.cpg_users AS u WHERE user_id= ............ '1' and user_group_list <> ''; (0s) [7] => SELECT MAX(group_quota) as ............ , MIN(group_quota) as disk_min, MAX(can_rate_pictures) ............ , MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX( ............ ) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN( ............ ) as pub_upl_need_approval, MIN( priv_upl_need_approval) as ............ FROM cpg_usergroups WHERE group_id in (1) (0s) [8] => SELECT group_name FROM ............ FROM cpg_albums WHERE aid='20' (0s) [14] => INSERT INTO cpg_pictures (aid, filepath, filename, ............ , '480009', '1360', '2048', '1176280572', '1', 'Admin','', '', '', 'YES', '', '', '', '', '125.239.206. ............ ] => picture ) ========================== VERSION INFO : ------------------ PHP version: 4.4.4 - OK --- ............ --------------- mySQL version: 4.1.21-standard-log ------------------ ............ (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support: GIF Read ............ Support: ========================== Module: mysql ------------------ MySQL Supportenabled Active ............ Links 0 Active Links 1 Client API version 4.1.21 ............ external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE - ............ /usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient ............ - ZLib Support enabled Compiled Version 1.2.1.2 Linked Version 1.2.1.2 ========================== ............ | no value safe_mode_gid | Off | Off safe_mode_include_dir | no value | no value safe_mode_exec_dir ............ | no value | no value file_uploads | On | On include_path | .:/usr/lib/php:/usr/local/lib/php | .: ............ | no value | no value sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i SMTP | ............ | Master Value max_execution_time | 30 | 30 max_input_time | 60 | 60 upload_max_filesize | 24M | 24M ............ 8M | 8M ========================== Page generated in 2.21 seconds - 16 queries in 0 seconds - Album ......
...... recently upgraded my coppermine gallery from 1.35 to 1.48 Whenever i or any ............ try to view a picture i recieve this error message. While executing query "INSERT INTO ............ , browser = 'Microsoft Internet Explorer 6.0', ............ = 'Windows XP'" on 0 mySQL error: Unknown column 'Ip' ............ 'field list' please help me Thank ......
...... upgraded to the new version and got these fatal error: While executing query "SELECT u.user_id AS id, ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ AS group_id FROM `beaalonz_copp1`.cpg_users AS u INNER JOIN `beaalonz_copp1`.cpg_usergroups AS g ON u. ............ .group_id WHERE u.user_id='1'" on Resource id #5 mySQL error: Unknown column 'u.avatar_url' in 'field ......
57
cpg1.4 upload / Hi, I need some help, "There was an error while processing a database query"
« by Pacos on January 01, 2006, 08:54:42 am »...... , I followed the instructions on Troubleshooting the error Im coming ............ with uploading files and realized that this error even cause me ............ ... Here's What I've Got, This was when I was trying to upload an image: Quote There was an error ............ processing a database query. While executing query "INSERT ............ '', '165.247.85.50', '165.247.85.50', '0')" on 0 mySQL error: Unknown column 'position' in 'field list' ............ tried to create a test user: Quote There was an error while processing a database query. While ............ SET user_name = 'testman', user_email = 'pacos@gamingextremes.us', user_active = 'YES', user_group = ' ............ ', user_profile1 = '', user_profile2 = '', user_profile3 = '', ............ = '', user_profile6 = '', user_group_list = '', user_password = 'testpass' WHERE user_id = ' ............ '" on 0 mySQL error: Unknown column 'user_profile1' in 'field ............ ' I have the Debug Info Available and will post it if you deem it ............ now and I'd like to be able to get it working again! Thanks for your help! ......
58
cpg1.4 upload / File uploads, but error when assigning category
« by PaveFE on January 01, 2006, 02:38:32 am »...... all, I've seen similar error messages, but here's mine: While executing query ............ "INSERT INTO cpg_pictures (pid, aid, filepath, ............ '', '68.84.159.184', '68.84.159.184', '0')" on 0 mySQL error: Unknown column 'position' in 'field list' ......
...... by Stram 1.4.18, and well after i added everything i got this fatal error: While executing query " ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ group_id FROM `ashhil_gallery`.cpg14x_users AS u INNER JOIN `ashhil_gallery`.cpg14x_usergroups AS g ............ .group_id WHERE u.user_id='1'" on Resource id #5 mySQL error: Unknown column 'u.avatar_url' in 'field ............ ' I read a topic about something like this and removed Code: [Select] , u.{$f[' ............ ']} AS avatar_url from the udb_base.inc.php file in the bridge album, and i am still ............ fatal error... and i got this fatal error when i logged in to ............ gallery... why do i get this fatal error and how can i fix it Please Answer Love, Ashhil ......
60
cpg1.2 PHPnuke/Postnuke Support / mySQL error: Unknown column 'pic_raw_ip'
« by kings4life on December 02, 2003, 11:07:08 pm »...... executing query "INSERT INTO cpg_pictures (pid, aid, ............ , pic_hdr_ip) VALUES ('', '1', 'modules/coppermine/albums/userpics/10002/', 'Car Show 031.jpg', ' ............ Car!!', '', 'YES', '', '', '', '', '', '')" on 0 mySQL error: Unknown column 'pic_raw_ip' in 'field list' ............ Just wondering if someone could help me out. THANKS. This ......