Search Results

Search results for: mySQL error Unknown column user_profile1 in field list

Pages: 1 2 [3] 4 5 6 7

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 ......

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' ......

cpg1.4 modpack by Stramm / Fatal Error

« by ashhil on June 22, 2008, 11:18:20 pm »

...... 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 ......

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 ......

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! ......

cpg1.5 upgrading / Re: Fatal error :

« by Joe Carver on July 18, 2011, 11:49:57 pm »

...... /update.php?theme=curve Then: You are NOT logged in AND you are in the Curve theme. 2) You try to ............ in from the link on the update page or this one: ............ ://ultimate-tlc.flirtatious.org/gallery/login.php?theme=curve Then: This error message - 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' ............ edit php files. Please also note that automatic installations and updates are not normally supported, ............ because of the types of trouble you are now seeing. +++++++ @ Αndré, If somehow the user ............ logged out and broken the gallery during a failed upgrade, could update.php be slightly ............ so that an unlogged admin could run it? Perhaps even under a different name ......

cpg1.4.x Deutsch (German) / Re: Aktivieren des Bridging zu mybb schlägt fehl, da keine connection zur datenbank.

« by Αndré on August 26, 2009, 11:23:42 am »

...... from: svenkaiser on August 26, 2009, 11:16:02 am mySQL error: Unknown column 'u.uid' in 'field list' ......

cpg1.4 upgrading / Re: Can this be fixed?

« by TFTN on October 10, 2012, 04:09:14 am »

...... to work. It looks much better but,, there are SQL errors now. I'm digging around trying to figure out ............ 's the problem now. Here is the error. "While executing query "SELECT pid, filepath, ............ WHERE ((aid='89' ) ) ORDER BY pid DESC " on 0 mySQL error: Unknown column 'owner_name' in 'field list' ............ " Thanks again for the help. I know just enough about these ......

cpg1.4.x Español (Spanish) / Re: Error al procesar la consulta

« by pau_cg on November 22, 2010, 04:42:42 pm »

...... datos? Yo no entiendo mucho pero segun marca el error "mySQL error: Unknown column 'owner_name' in ' ............ list'" hay una columna que esta faltando. Eso tiene ......

cpg1.4 bridging / database error bridging phpbb3 upgrade

« by teleferico on September 04, 2009, 04:56:32 am »

...... have the following issue when trying to bridge coppermine and ............ : While executing query "SELECT u.user_id AS user_id, u. ............ ' AND u.user_id > 0" on 0 mySQL error: Unknown column 'u.user_level' in 'field ............ ' Coppermine install: http://www.greatamericaparks.com/images/ ............ Forum install: http://www.greatamericaparks.com/forums/ ............ account: cpgtest / temppass BridgeManager settings: Forum URL: not set Relative path to your BBS' ............ set 1. I upgraded from PHPBB2 to PHPBB3, creating a new database for PHPBB3. Prior to the upgrade, ............ I deactivated bridging. 2. I performed the steps in the PHPBB3 Bridge ............ 's first post: http://forum.coppermine-gallery.net/index.php/topic,53678.0.html . I did ............ the optional step. 3. I knew that the Coppermine tables were in the old database, but not in the ............ . I was unable to determine from the documentation whether the BridgeManager ............ step through migrating those tables to the new database or not. 4. I ............ /images/bridgemgr.php 5. It returned: There was an error while processing a database query. 6. Coppermine ............ down with "Fatal error:". 7. Debug mode revealed the full error message ............ at the top of this post. 8. Searching the forum, I've been unable to find an answer as ............ the proper method of migrating old Coppermine tables from the PHPBB2 database ............ . There is also the issue of the new database being UTF-8 and the old one was not. What must I do ......

cpg1.5 upgrading / Upgrade Fatal Error..

« by Toblet on August 21, 2011, 11:07:22 am »

...... guys, I get this fatal error after I upgraded: Fatal Error: While executing ............ 'SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MIN(can_rate_pictures) ............ can_rate_pictures, MIN(can_send_ecards) as can_send_ecards, MAX( ............ ) as ufc_max, MIN(upload_form_config) as ufc_min, MIN( ............ , MAX(num_URI_upload) as num_URI_upload, MIN(can_post_comments) as can_post_comments, MIN( ............ ) as can_upload_pictures, MIN(can_create_albums) as can_create_albums, MAX( ............ ) as has_admin_access, MAX(pub_upl_need_approval) as ............ FROM cpg1410_usergroups WHERE group_id in (103)' in bridge/e107.inc.php on line 471 mySQL ............ : Unknown column 'upload_form_config' in 'field list' Does ............ I posted it here I could see at the end it says line 471 in my bridge file?? ......

cpg1.5 plugins / Re: AJAX Captcha ver 2.0 and critical database error

« by kaval on June 30, 2011, 10:31:27 pm »

...... you try actually registering and then replying to the email? As an admin, I ............ that user has registered in gallery, but I do not get the rest of the text ............ I have left debug mode on for now. Below are some error messages: While executing query 'SELECT ............ = '582b45be5bba144f28d7880796d54e77' LIMIT 1' in register.php on line 708 mySQL error: Unknown ............ 'user_email_valid' in 'field list' THIS IS THE CRITICAL DATABASE ERROR ............ : [Select] Additional debug verbose info below: USER: ------------------ Array ( [ ............ [access_level] => 2 [disk_max] => 0 [disk_min] => 0 [has_admin_access] => 0 [group_name] ............ [0] => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (0 ms) [1] => SELECT * ............ cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:54] ............ 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:264] (1 ms) [3] => SELECT user_id, ............ `.cpg15x_users WHERE user_id = 0 [bridge/coppermine.inc.php:276] (0 ms) [4] => 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 cpg15x_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:323] (0 ms) [5] = ............ WHERE group_id= 3 [bridge/udb_base.inc.php:327] (1 ms) [6] => SELECT COUNT(*) FROM ............ WHERE group_id in (3) [bridge/udb_base.inc.php:340] (0 ms) [7] = ............ 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:321] (0 ms) [8] => SELECT aid FROM ............ WHERE moderator_group IN (3) [include/init.inc.php:271] (0 ms) [9] => ............ FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms) [10] => DELETE ............ WHERE expiry < '2011-06-30 15:24:00' [include/init.inc.php:443] (0 ms) [11] => SELECT ............ .48.130' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms) [12] => SELECT ............ != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:976] (0 ms) [ ............ [access_level] => 2 [disk_max] => 0 [disk_min] => 0 [has_admin_access] => 0 [group_name] ............ [0] => SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (0 ms) [1] => SELECT * ............ cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:54] ............ 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:264] (0 ms) [3] => SELECT user_id, ............ `.cpg15x_users WHERE user_id = 0 [bridge/coppermine.inc.php:276] (0 ms) [4] => 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 cpg15x_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:323] (0 ms) [5] = ............ WHERE group_id= 3 [bridge/udb_base.inc.php:327] (0 ms) [6] => SELECT COUNT(*) FROM ............ WHERE group_id in (3) [bridge/udb_base.inc.php:340] (0 ms) [7] = ............ 'bb09bdc583bef336f9c5bb92482ce03e' [bridge/coppermine.inc.php:321] (0 ms) [8] => SELECT aid FROM ............ WHERE moderator_group IN (3) [include/init.inc.php:271] (0 ms) [9] => ............ FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms) [10] => DELETE ............ WHERE expiry < '2011-06-30 15:22:30' [include/init.inc.php:443] (0 ms) [11] => SELECT ............ .48.130' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms) [12] => SELECT ............ != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:976] (0 ms) [ ............ @yahoo.com' [register.php:565] (3 ms) [17] => INSERT INTO cpg15x_users (user_regdate, user_active, ............ , user_name, user_password, user_email, user_profile1, user_profile2, user_profile3, user_profile4, ............ => test [email] => mpatelkaval@yahoo.com [user_profile1] => test [user_profile2] => [ ............ ] => [agree] => 1 [recaptcha_challenge_field] => 03AHJ_Vus1yftBn5M_MCrffdqVgHNVBovqvQ- ............ -k4GlokKZDg [recaptcha_response_field] => major bumenta [submit] => Submit ......

cpg1.4.x Italian (Italiano) / Re: Erroe Critico: C'è stato un errore processando una query al database

« by Martina89 on November 26, 2010, 02:29:30 pm »

...... fuori utilizzando il debug mode While executing query "SELECT pid, filepath, filename, ............ , pheight, ctime, aid, keywords, votes, pic_rating, title, caption,hits,owner_id,owner_name from ............ ((aid='106' ) ) ORDER BY filename ASC " on 0 mySQL error: Unknown column 'owner_name' in 'field list' ............ Array ( [user_id] => 1 [user_name] => Martina [groups] => Array ( => ............ ) [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 [ ............ cpg_filetypes; (0s) [1] => select * from cpg_plugins order by priority asc; (0s) [2] => delete ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ AS group_id FROM `frankies_copp1`.cpg_users AS u INNER JOIN `frankies_copp1`.cpg_usergroups AS g ON u. ............ u.user_id='1' (0s) [7] => SELECT user_group_list FROM `frankies_copp1`.cpg_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 cpg_usergroups WHERE group_id in (1) (0s) [9] => SELECT group_name FROM ............ , pheight, ctime, aid, keywords, votes, pic_rating, title, caption,hits,owner_id,owner_name from ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 5.2.9 - OK --- ............ --------------- mySQL version: 5.0.91-community ------------------ ............ (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.0.91 ............ external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE - ............ /usr/include/mysql MYSQL_LIBS -L/usr/lib64 - ............ 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 ............ , popen, allow_url_fopen 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 | 360 | 360 max_input_time | 60 | 60 upload_max_filesize | 10M | 10M ............ 8M | 8M ========================== Page generated in 0.03 seconds - 23 queries in 0 seconds - Album ......

cpg1.5.x Español (Spanish) / Re: PROBLEMAS ACTUALIZACIÓN GALERÍA

« by anica1410 on November 29, 2010, 11:24:31 am »

...... entrado a este post: http://forum.coppermine-gallery.net/index.php?topic=35093.0 Y he ............ el debug mode (supongo que para que me indique la clase de error): http://coppermine- ............ .net/tutorial/debug_mode.php Y al entrar el error que me da es este: Critical error There was an ............ while processing a database query. While executing query 'SELECT ............ depth BETWEEN 0 + 1 AND 0 + 1 ORDER BY c.lft' in index.php on line 316 mySQL error: Unknown ............ 'depth' in 'field list' File: /home/a7788959/public_html/ ............ /functions.inc.php - Line: 263 .............................. ............ ............ Luego al expandir el debug (en la página central), me sale esto: USER: ----------------- ............ => 1 ) [disk_max] => 0 [disk_min] => 0 [can_rate_pictures] => 1 [ ............ ] => 1 [can_create_albums] => 1 [has_admin_access] => 1 [access_level] => 3 [ ............ ] => 0 [group_name] => Administrators [group_quota] => 0 [ ............ ( => SELECT name, value FROM cpg14x_config [include/init.inc.php:181] (1 ms) [1] => SELECT * ............ cpg14x_plugins ORDER BY priority [include/plugin_api.inc.php:53] ............ time < 1291022332 AND remember = 0 [bridge/coppermine.inc.php:248] (1 ms) [3] => DELETE FROM ` ............ WHERE time < 1289816332 [bridge/coppermine.inc.php:252] (1 ms) [4] => UPDATE ............ () WHERE name = 'session_cleanup' [bridge/coppermine.inc.php:256] (1 ms) [5] => SELECT user_id, ............ '4e56bd1156d265b740b69098c8a0e120' [bridge/coppermine.inc.php:264] (1 ms) [6] => SELECT user_id, ............ `.cpg14x_users WHERE user_id = 1 [bridge/coppermine.inc.php:276] (1 ms) [7] => SELECT u.user_id ............ FROM `a7788959_efybv`.cpg14x_users AS u LEFT JOIN `a7788959_efybv`.cpg14x_usergroups AS g ON u. ............ =g.group_id WHERE u.user_id='1' [bridge/udb_base.inc.php:70] (1 ms) [8] => SELECT user_group_list ............ AS u WHERE user_id='1' AND user_group_list <> '' [bridge/coppermine.inc.php:202] (1 ms) [ ............ ] => 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 cpg14x_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:321] (1 ms) [10] ............ WHERE group_id= 1 [bridge/udb_base.inc.php:325] (0 ms) [11] => SELECT lang_id FROM ............ WHERE enabled='YES' [include/init.inc.php:329] (1 ms) [12] => SELECT ............ FROM cpg14x_favpics WHERE user_id = 1 [include/init.inc.php:387] (37 ms) [13] => SELECT ............ .199' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (6 ms) [14] => SELECT ............ , thumb FROM cpg14x_categories WHERE cid = 1 [index.php:268] (1 ms) [15] => SELECT COUNT( ............ pic_count FROM cpg14x_albums AS a INNER JOIN cpg14x_pictures AS p ON p.aid = a.aid ............ a.category > 10000 AND approved = 'YES' [index.php:292] (1 ms) [16] => SELECT name, ............ depth BETWEEN 0 + 1 AND 0 + 1 ORDER BY c.lft [index.php:316] (0 ms) [17] => SELECT COUNT(*) ............ cpg14x_pictures WHERE approved = 'NO' [include/functions.inc.php:2409] (1 ms) [18] => ............ WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2315] (1 ms) [19] => ............ = 'b3e267b022691eed605e8e506ba77e87' LIMIT 1 [include/functions.inc.php:4879] (243 ms) [20] => ............ message_id = 'b3e267b022691eed605e8e506ba77e87' [include/functions.inc.php:4890] (79 ms) [21] => ............ cpg14x_temp_messages WHERE time < 1291022332 [include/functions.inc.php:4911] (52 ms) ) ========== ............ [coppermine_data] => ............ ) ========================== VERSION INFO : ------------------ PHP version 5.2.11 ............ OK MySQL version 5.0.81-community OK Coppermine ............ 1 FreeType Linkage with freetype ............ ========================== Key config settings ------------------ site_url http:// ............ .webcindario.com/ charset utf-8 ............ cookie_name coppermine cookie_path / ............ english main_page_layout breadcrumb/catlist/alblist/lastup, ............ ========================== Plugins ------------------ ========================== ............ safe_mode_include_dir ............ , shell_exec, proc_open, passthru, set_time_limit, ini_restore, mysql_list_dbs, ini_alter, dl, ............ , openlog, syslog, symlink, link, chgrp, leak, popen, escapeshellcmd, ............ include_path .:/usr/lib/php:/usr/local/ ............ max_input_time 10 ............ suhosin.post.max_vars 500 ............ suhosin.request.max_vars 500 ......

cpg1.4 upgrading / Re: Oops. Critical Error - Unknown column....

« by Hein Traag on June 26, 2007, 07:55:17 am »

...... you use Fantastico or some other automatic installed for cpg ? The error message " mySQL error: ............ column 'randpos' in 'field list'" usually is caused by ......

cpg1.5 plugin contributions / Re: XFeed RSS/Atom feed plugin for CPG 1.5.x

« by jayhunter on October 09, 2010, 01:01:33 pm »

...... - I appreciate the fast response and tried again. Unfortunately it still result in error here, but ............ slightly different error this time. No problem .. Quote from: ............ on October 09, 2010, 12:22:37 pm ' in plugins/xfeed/codebase.php on line 321 <<<--- ............ has changed from line 326 to 321 mySQL error: Unknown column ' ............ ' in 'field list' The error has change quite a bit ............ delete xfeed. For me it worked just by removing it throu the plugin manager (not just uninstall!) ............ . Please remove the plugin, delete the plugins/xfeed folder and - very ............ - check the database directly (phpmyadmin) if the table 'cpg15x_plugin_xfeeds' got removed. ............ , do that by hand. Now you are ready to try again. Quote from: photo2pictures on October 09, 2010, ............ ..? Chmod or the server configuration has nothing to do with this. It's a database related error. ............ you get it working. Cheers ......

cpg1.5 upgrading / Re: Fatal error (and nothing else - no error message)

« by aglae on August 18, 2011, 05:37:19 pm »

...... I get : mySQL error: Unknown column 'owner_name' in 'field list' ............ when trying to display a gallery. Any idea ? It seems pretty ............ but I don't know much about managing that kind of stuff. Thanks ......

cpg1.5.x Français (French) / Re: Galerie Out

« by Shallya on May 12, 2011, 11:07:55 am »

...... qu'il y avait une erreur de frappe dans config.inc... Maintenant la galerie s'affiche mais avec un ............ message d'erreur Quote While executing query 'SELECT name, description, cid, thumb, ............ depth BETWEEN 0 + 1 AND 0 + 2 ORDER BY c.lft' in index.php on line 316 mySQL error: Unknown ............ 'depth' in 'field list' ......

cpg1.4 install / Re: Comments won't display please help urgently

« by krupa on November 05, 2010, 03:04:37 pm »

...... thanks for replying. Right i ran the update, but its still running ............ an error. This is what it said: There was an error while ............ a database query. While executing query "SELECT msg_id, msg_author, msg_body, ............ WHERE pid='431' ORDER BY msg_id ASC" on 0 mySQL error: Unknown column 'msg_author' in 'field list' ......

cpg1.4 upload / Re: Error uploading after increasing Custom Fields

« by Rai on December 20, 2007, 05:48:18 pm »

...... December 20, 2007, 04:58:37 pm Review the posts in the mod's thread as your problem is discussed ............ . See particularly http://forum.coppermine-gallery.net/index.php?topic=23695.msg142556# ............ . Oops, I figured I'd missed something but got lost. I made the change and now I'm ............ this error: Quote While executing query "INSERT INTO ............ ', '269494', '640', '480', '1198168396', '1', 'admin','', '', '', 'YES', 'LOC', 'EVENT', 'NAMES', ' ............ ', '38.105.83.34', '38.105.83.34', '0')" on 0 mySQL error: Unknown column 'user5' in 'field list' I' ............ attached the debug info (it was to long to include) I've also attached ............ admin file with the changes (did I put it in wrong?) ......

cpg1.4 upload / Upload Issue

« by luvthmud on October 07, 2006, 09:05:00 am »

cpg1.3 Miscellaneous / error while processing a database query

« by Quinti on May 29, 2006, 03:09:24 pm »

...... people my gallery show me this error: Quote error while processing a database query. ............ Code: [Select] While executing query "UPDATE cpg133_pictures SET randpos = ............ (RAND()*1) WHERE 1" on 0 mySQL error: Unknown column 'randpos' in 'field list' ............ file: /var/www/vhosts/fotosdesarria.com/httpdocs/include/functions.inc.php - Line: 105 mmm..what i ............ do? show you the debug info? help please....... thank u very ......

cpg1.3.x Support / MySQL Error - lasthit_ip issues

« by SaigonK on June 17, 2004, 12:32:01 pm »

...... after updating my schema.sql file from the CVS, it appears ............ is a missing table or something in my database. Here is the ............ i get in debug mode: Any thoughts? There was an error ............ processing a database query. While executing query "UPDATE ............ ='216.227.168.186' WHERE pid='5385'" on 0 mySQL error: Unknown column 'lasthit_ip' in 'field list' ............ File: /home/is12net/public_html/gallery/include/functions.inc.php - Line: ......

cpg1.3.x Support / Moved to new server; started having errors

« by aravot on August 11, 2005, 03:36:57 am »

...... 1.3.3 Moved to new server, now I am getting the following error, uploaded fresh theme.php ............ functions.inc.php no change. Quote Warning: Cannot modify ............ information - headers already sent by (output ............ at /home/mysite.com/public_html/cpg/index.php:751) in /home/mysite.com/public_html/cpg/ ............ /classic/theme.php on line 810 Warning: Cannot modify header information - ............ started at /home/mysite.com/public_html/cpg/index.php:751) in /home/mysite.com/public_html/cpg/ ............ /classic/theme.php on line 811 Warning: Cannot modify header information - ............ started at /home/mysite.com/public_html/cpg/index.php:751) in /home/mysite.com/public_html/cpg/ ............ /functions.inc.php on line 51 Quote There was an error while ............ a database query. While executing query "UPDATE cpgpictures SET randpos = ROUND( ............ ()*0) WHERE 1" on 0 mySQL error: Unknown column 'randpos' in 'field list' ............ Debug Info: Quote USER: ------------------ Array ( [ ............ ----------- Array ( [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] => 0 [pub_upl_need_approval] => 1 ............ user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '*' [2] => SELECT MAX( ............ ) as disk_max, 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 cpgusergroups WHERE group_id in (3) [3] => SELECT group_name FROM ............ , pwidth, pheight FROM cpgalbums as a LEFT JOIN cpgpictures as p ON a.thumb=p.pid WHERE category= ............ (ctime) as last_upload FROM cpgpictures WHERE aid IN (28, 29, 30, 31) AND approved = 'YES' GROUP BY ............ ] => SELECT count(*) FROM cpgpictures as p LEFT JOIN cpgalbums as a ON a.aid=p.aid WHERE 1 [23] => ............ count(*) FROM cpgcomments as c LEFT JOIN cpgpictures as p ON c.pid=p.pid LEFT JOIN ............ ] => SELECT sum(hits) FROM cpgpictures as p LEFT JOIN cpgalbums as a ON p.aid=a.aid WHERE 1 [26] => ............ ( ) ========================== Page generated in 0.546 seconds - 33 queries in 0.01 seconds - ......

cpg1.4 bridging / Error Querying Database.. Xoops bridged to coppermine 1.4.2

« by foz on December 14, 2005, 07:37:20 pm »

...... have the following problem when bridging Xoops 2.2.3 final with ............ the ecard or report feature. These features work fine with the bridge disabled. Also I have tried it ............ and without post based groups. Changing that made no difference. Also using search I ............ not find a similar problem Quote Critical error ............ was an error while processing a database query. While ............ `.***_users WHERE uid = '1'" on Resource id #6 mySQL error: Unknown column 'user_regdate' in 'field ............ File: /****/******/public_html/testsite/cpg142/include/functions.inc.php - Line: 248 Thanks for ............ help in advance foz Coppermine install: http://www. ............ .com/testsite/cpg142 Forum install: http://www.thewoodlandsmonitor.com/testsite ............ version: 1.4.2 Forum Version: Xoops 2.2.3 final Test user account: Testuser/test Bridgemanager ......

cpg1.4 ecards & email / [Solved]: Database error when clicking ecard

« by rgarrison on April 05, 2008, 05:36:04 pm »

...... my PHP yesterday to 5.2.5 and now I have weird things in my gallery. When you click on ecard on any ............ you get a There was an error while processing a database query: While ............ WHERE id_member = '1'" on Resource id #6 mySQL error: Unknown column 'ddate_registered' in ' ............ list' File: /var/www/vhosts/bonniebacon.com/httpdocs/ ............ /include/functions.inc.php - Line: 249 USER: ------- ............ ] => 104 ) [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] => 0 [has_admin_access] => 1 [pub_upl_need_approval] => 0 ............ ] => 1 [group_name] => Administrator [upload_form_config] => 3 [ ............ ; (0.001s) [1] => select * from cpg14x_plugins order by priority asc; (0.001s) [2] => ............ ) [3] => SELECT MAX(group_quota) as disk_max, 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 cpg14x_usergroups WHERE group_id in (101,104) (0.001s) [4] => SELECT group_name ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 5.2.5 - OK --- ............ --------------- mySQL version: 5.0.45 ------------------ Coppermine ............ doesn't exist ========================== Module: mysql ------------------ MySQL Supportenabled Active ............ Links 0 Active Links 1 Client API version 5.0.45 ............ external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE - ............ /usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql - ............ 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 ............ | no value | no value file_uploads | On | On include_path | .:/usr/share/pear:/usr/share/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 | 2M | 2M ............ 8M | 8M ========================== Page generated in 0.244 seconds - 10 queries in 0.01 seconds - ......

cpg1.4 upgrading / Please Help me Critical Database error

« by Tango589 on February 14, 2006, 08:30:05 pm »

...... index.php opens up fine and you see all of my ............ , and all the albums contained in them. But when you click on an album to ............ the photos inside of it, you get this: Critical Error There ............ an error while processing a database query. and the debug ............ me this>>>> While executing query "SELECT category, title, aid, keyword, ............ , alb_password_hint FROM cpg_albums WHERE aid='36'" on 0 mySQL ............ : Unknown column 'alb_password_hint' in 'field list' what ............ I had CPG 1.3x and moved it to a new host and now installed CPG 1.4x, and just used the; Albums, ............ , Pictures, Users database tables from my other installation... P.S. I can get into any other view.. ............ I can view my album in catergory view, I can open any photo, and once I ............ ones around it.. I seem to be able to do everything but open up individual albums.. ......

cpg1.3 Miscellaneous / Critical Error

« by Shelia on September 14, 2005, 05:44:21 am »

...... am a new user and my Gallery has worked just fine for about a week. Tonight the following error ............ While executing query "SELECT pid, filepath, filename, ............ = 'YES' ORDER BY pid DESC LIMIT 0 ,8" on 0 mySQL error: Unknown column 'owner_id' in 'field list' ............ I checked my database and in cpg133_pictures owner_id seems to be missing. Can ............ post the mysql information for me to add to my database assuming ............ is the problem referred to in the error? Thanks, ......

cpg1.4 modpack by Stramm / Still getting fatal error

« by chula on May 23, 2008, 01:31:12 am »

...... so i thought my gallery is fine because the thumbnails are showing up on the ............ I clicked on the images, I got these While executing query "SELECT c.msg_id, c.msg_author, c.msg_body, ............ AS avatar_url FROM cpg_comments AS c LEFT JOIN `beaalonz_copp1`.cpg_users AS u ON c.author_id=u. ............ ='3704' ORDER BY c.msg_id DESC" on Resource id #5 mySQL error: Unknown column 'u.avatar_url' in 'field ............ ' File: /home/beaalonz/public_html/gallery/include/functions.inc.php - Line: 248 USER: ------ ............ ] => 0 [disk_max] => 0 [disk_min] => 0 [ufc_max] => 0 [ufc_min] => 0 [ ............ cpg_filetypes; (0s) [1] => select * from cpg_plugins order by priority asc; (0s) [2] => delete ............ ) [6] => SELECT MAX(group_quota) as disk_max, 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 (3) (0s) [7] => SELECT group_name FROM ............ ) from cpg_pictures WHERE approved = 'YES' AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50, ............ * FROM cpg_pictures WHERE approved = 'YES' AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50, ............ AS avatar_url FROM cpg_comments AS c LEFT JOIN `beaalonz_copp1`.cpg_users AS u ON c.author_id=u. ............ ( ) ========================== Page generated in 0.17 seconds - 17 queries in 0.02 seconds - Album ............ : AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50, ............ ,90,91,92,93,94,95,96,97,98) ; Meta set: AND aid IN (34,35,36,37,38,39,40,41,42,43,44,45,46,47,49,50, ............ please? My gallery is www.bea-alonzo.com/gallery/index.php Thank ......

cpg1.3.x Support / 'Critical Error'

« by kittsbud on January 05, 2006, 08:05:36 pm »

...... attempted to restore the rest of the site something happened. I'm now getting a 'critical error' ............ inside a table at the bottom of my index page. ............ the table it say an error occured while accessing the database. In debug ............ I get this HUGE piece of info Code: [Select] USER: ------------------ Array ( ............ ] => 2005-09-19 15:14:05 [user_group_list] => [user_email] => [user_profile3] => ............ [user_profile1] => [user_profile2] => [user_profile4] = ............ [user_profile6] => [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 [ ............ user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = ' ............ ' [2] => SELECT MAX(group_quota) as disk_max, 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) [3] => SELECT group_name FROM ............ ] => SELECT count(*) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1 [46] => ............ SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN ............ => SELECT sum(hits) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON p.aid=a.aid WHERE 1 [49] => ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 4.3.11 - OK -- ............ ---------------- mySQL version: 4.0.25-standard ------------------ ............ compatible) FreeType Support enabled FreeType Linkage with freetype GIF Read Support enabled GIF ............ enabled ========================== Module: mysql ------------------ Active Persistent Links 5 ............ Links 6 Client API version 4.0.25 MYSQL_MODULE_TYPE ............ MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE - ............ /usr/include/mysql MYSQL_LIBS -L/usr/lib -lmysqlclient ............ --- ZLib Support enabled Compiled Version 1.1.4 Linked Version 1.1.4 ========================== ............ | no value safe_mode_gid | Off | Off safe_mode_include_dir | no value | no value safe_mode_exec_dir ............ ,passthru,shell,shell_exec 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 | -1 | -1 upload_max_filesize | 5M | 5M ............ | 55M ========================== Page generated in 0.18 seconds - 54 queries in 0.109 seconds - ............ set : my host says they've never seen anything like it. Can you guys help, as code means ............ You need to scroll down to see the table with the error in! Thanks Update: I found this error ............ also while in debug Code: [Select] While executing query " ............ SET randpos = ROUND(RAND()*30) WHERE 1" on 0 mySQL error: Unknown column 'randpos' in 'field list' ......