- April 27, 2024, 01:18:31 pm
- Welcome, Guest
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
Search results for: mySQL error Unknown column user_profile1 in field list
181
cpg1.4 plugin contributions / Re: Users Online Today
« by will on November 19, 2007, 01:27:40 pm »...... this plugin a while but I haven't used it until now, I get ............ database query error and this mysql error: While executing query " ............ WHERE user_lastvisit LIKE '2007-11-19%'" on 0 mySQL error: Unknown column 'user_id' in 'field list' ............ bridged, is this why? If so is there a way of making it work with my bridged gallery ......
182
cpg1.4.x Français (French) / Re: ModPack Stramm problème
« by camille003 on April 22, 2007, 03:48:12 pm »...... le Fatal Error j'ai ça : Quote While executing query "SELECT u. ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ AS group_id FROM `ellegalerie`.cpg1410_users AS u INNER JOIN `ellegalerie`.cpg1410_usergroups AS g ON ............ .group_id WHERE u.user_id='1'" on Resource id #5 mySQL error: Unknown column 'u.avatar_url' in 'field ......
183
cpg1.4 miscellaneous / Re: profile.php?op=edit_profile error
« by bumblebeestudio on May 18, 2006, 05:06:14 pm »...... to post and not search...I see now that this is a mySQL error, not a program error. I don't know the ............ I can study and figure it out... While executing query "SELECT user_name, user_email, user_group, ............ ) as user_regdate, group_name, user_location, user_interests, user_website, user_occupation, ............ as disk_usage, group_quota FROM cpg140_users AS u INNER JOIN cpg140_usergroups AS g ON user_group = ............ LEFT JOIN cpg140_pictures AS p ON p.owner_id = u.user_id ............ user_id ='1' GROUP BY user_id " on 0 mySQL error: Unknown column 'user_location' in 'field ............ ' File: /hsphere/local/home2/designho/kifa.us/art/include/functions.inc.php - Line: 105 USER: ------ ......
184
cpg1.4 upload / Re: Recent upgrade - now problems with Batch Adding
« by asprn on August 31, 2006, 10:38:33 pm »...... [0] => 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] => 1 ............ ] => 0 [group_name] => Administrators [upload_form_config] => 3 [ ............ ; (0s) [1] => select * from cpg11d_plugins order by priority asc; (0s) [2] => delete ............ group_id FROM `cm_album_copp1`.cpg11d_users AS u INNER JOIN `cm_album_copp1`.cpg11d_usergroups AS g ............ u.user_id='1' (0s) [7] => SELECT user_group_list FROM `cm_album_copp1`.cpg11d_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 cpg11d_usergroups WHERE group_id in (1) (0s) [9] => SELECT group_name FROM ............ ============ GET : ------------------ Array ( [insert] => 1 ) ========================== POST : --- ............ ] => dXBsb2Fkcy90ZXN0L2R1Zy5qcGc= [insert] => Insert selected files ) ================= ............ ========= VERSION INFO : ------------------ PHP version: 4.4.3 - OK --- ............ --------------- mySQL version: 4.1.21-standard ------------------ ............ (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 | 2M | 2M ............ 8M | 8M ========================== Page generated in 0.065 seconds - 16 queries in 0.003 seconds - ............ set : ; Meta set: ; After clicking on the Result (as above), the critical error ............ the following code:- Code: [Select] While executing query " ............ INTO cpg11d_pictures (aid, filepath, filename, ............ '', '', 'YES', '', '', '', '', '', '', '0')" on 0 mySQL error: Unknown column 'position' in 'field list' ............ insight much appreciated - thanks. ......
...... OTHERS TOPICS AND I VIEW THE "DEBU MODE" OR SOMETHING LIKE THAT AND THERE SHOW THIS: Quote While ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ FROM `pn_1817754_ashley`.cpg144x_users AS u INNER JOIN `pn_1817754_ashley`.cpg144x_usergroups AS ............ .group_id WHERE u.user_id='1'" on Resource id #6 mySQL error: Unknown column 'u.avatar_url' in 'field ......
...... sorry: While executing query "INSERT INTO cpg1410_hit_stats ............ ='http%3A%2F%2Fpictures.jamaicacollege.org%2Findex.php', browser = ' ............ ', os = 'Windows XP'" on 0 mySQL error: Unknown column 'Ip' ............ 'field list' ......
...... i do it this is the error Quote While executing query "SELECT max_pics ............ WHERE aid = 12 AND limit_pics = 'YES'" on 0 mySQL error: Unknown column 'max_pics' in 'field list' ......
188
cpg1.3 Miscellaneous / Re: Critical error
« by fabiano werner on December 08, 2005, 01:46:31 am »...... u are: __________________ While executing query "UPDATE cpg_pictures SET randpos = ROUND( ............ ()*15) WHERE 1" on 0 mySQL error: Unknown column 'randpos' in 'field list' ............ i´m coming back from a whole system restore backup due to ............ while upgrading my Mambo to JOOMLA ... with no success, then ......
189
General discussion (no support!) / Re: upgrade's??
« by itchy on November 21, 2004, 07:40:13 pm »...... this is bizarre, some pages work and some dont, mainly any that involve showing the fronts off each ............ , things such as last uploads and upload approval work ............ . got into config and switched debug on. Heres the error ............ the first page. While executing query "SELECT cid, name, description, thumb FROM ............ WHERE parent = '' ORDER BY pos" on 0 mySQL error: Unknown column 'thumb' in 'field list' ......
190
cpg1.2 Standalone Support / There was an error while processing a database query.
« by Kronberg on February 22, 2004, 02:35:25 pm »...... I have same problem Quote While executing query "SELECT user_id, username as user_name, ............ WHERE user_id='0' AND user_password='*'" on 0 mySQL error: Unknown column 'username' in 'field list' ............ And I have not a dot in the database name, and it is actually there when ............ look in MYSQL What can I do??? Regards, ......
...... get the following now: Quote Fatal error: While executing query " ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ AS group_id FROM `juicyfla_copp1`.cpg_users AS u INNER JOIN `juicyfla_copp1`.cpg_usergroups AS g ON u. ............ .group_id WHERE u.user_id='62'" on Resource id #5 mySQL error: Unknown column 'u.avatar_url' in 'field ......
192
cpg1.3 Installation & Setup / Re: Upgrade without loss
« by Zerg on August 17, 2004, 07:48:52 am »...... . Debug Info Code: [Select] While executing query "SELECT ............ WHERE parent = '' ORDER BY pos" on 0 mySQL error: Unknown column 'thumb' in 'field list' ............ 0 [group_quota] => 0 [6] => 0 [has_admin_access] => 1 [7] => 1 [can_rate_pictures] ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 4.3.8 - OK --- ............ --------------- mySQL version: 4.0.20-log ------------------ Coppermine ............ compatible) FreeType Support enabled FreeType Linkage with freetype T1Lib Support enabled GIF ............ enabled ========================== Module: mysql ------------------ Active Persistent Links 1 ............ Links 2 Client API version 3.23.49 ............ builtin MYSQL_SOCKET /var/run/mysqld/mysqld.sock ............ no value MYSQL_LIBS no value ========================== Module: ............ --- ZLib Support enabled Compiled Version 1.1.4 Linked Version 1.2.1 ========================== ............ | 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/php:/usr/share/pear | .:/ ............ .com | me@localhost.com 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 | 2M | 2M ............ 8M | 8M ========================== Page generated in 0.039 seconds - 6 queries in 0.002 seconds - ......
193
cpg1.3 Permissions & Access Rights / Re: Unable to log in - CRITICAL ERROR
« by flightless on April 25, 2006, 09:11:24 am »...... did as requested above. This is the error message I am getting now: While executing query ............ cpg133_users WHERE user_name = '********' AND BINARY user_password_md5 = md5('******') AND ............ = 'YES'" on 0 mySQL error: Unknown column 'user_password_md5' in ' ............ list' My setup is at: http://www.lvanduyn.com/ ......
194
cpg1.4 miscellaneous / Re: Error message when creating new album
« by Orlando-D on April 01, 2007, 01:28:15 am »...... error There was an error while processing a database ............ . Quote While executing query "INSERT INTO cpg1410_albums (category, ............ Sacrifice Radio Promo CD', 'NO', '1', '')" on 0 mySQL error: Unknown column 'uploads' in 'field list' ............ -host.com/a/m/y/amyleerockfaerie/htdocs/Gallery/include/functions.inc.php - Line: 249 ......
195
Mods: Miscellaneous / Re: Additional Custom Fields
« by emaluzer on September 17, 2006, 12:51:12 am »...... tried all the steps outlined, now I cant upload a file, or edit a file. ............ I want to upload it gives me this error: Quote There was an error while processing a ............ query. While executing query "INSERT INTO cpg_pictures (aid, filepath, ............ , position) VALUES ('14', 'userpics/10001/', 'darkwing~6.jpg', '49408', '71641', '640', '480', ' ............ '', '', '65.43.167.8', '65.43.167.8', '0')" on 0 mySQL error: Unknown column 'user5' in 'field list' [ ............ GauGau]Removed debug_output from posting. Only post it if a supporters asks you to do so[/ ............ ] As you can see there is a user7 in the edit, and a user5 in the upload. After ............ problems with user5 I changed 5 to 7 in all the files, but for some reason it still ............ in the upload error. I believe that means I missed ............ neccessary user7 to my database as well as user_field7_name. I see this posted alot but no fix so ......
196
cpg1.4.x Français (French) / Re: [Plugin] Photo Summary: Affichage d'un index des photos de la galerie
« by sanlogik on November 12, 2006, 10:12:16 pm »...... écution de la requête. Code: [Select] While executing query "SELECT home,login,my_gallery,upload_pic, ............ ,favpics,search,photo_summary FROM cpg146_final_extract_config WHERE Group_Id=1" on 0 mySQL ............ : Unknown column 'photo_summary' in 'field list' Code: [ ............ [0] => 1 ) [disk_max] => 0 [disk_min] => 0 [can_rate_pictures] => 0 [ ............ ] => 0 [ufc_max] => 3 [ufc_min] => 3 [custom_user_upload] => 0 [ ............ ] => 1 [can_create_albums] => 0 [has_admin_access] => 1 [pub_upl_need_approval] => 0 ............ ] => 0 [group_name] => Administrators [upload_form_config] => 3 [ ............ ; (0.001s) [1] => select * from cpg146_plugins order by priority asc; (0.001s) [2] => ............ FROM `soundamentalorg1`.cpg146_users AS u INNER JOIN `soundamentalorg1`.cpg146_usergroups AS g ............ u.user_id='2' (0s) [7] => SELECT user_group_list FROM `soundamentalorg1`.cpg146_users AS u WHERE ............ ='2' 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 cpg146_usergroups WHERE group_id in (1) (0.001s) [9] => SELECT group_name FROM ............ cpg146_cms_config (0s) [14] => SELECT home,login,my_gallery,upload_pic,album_list,lastup,lastcom, ............ ,favpics,search,photo_summary FROM cpg146_final_extract_config WHERE Group_Id=1 (0.001s) [ ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 4.4.4 - OK --- ............ --------------- mySQL version: 5.0.26-max-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 5.0.22 ............ external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/opt/misc/ ............ /include/mysql MYSQL_LIBS -L/opt/misc/mysql/lib/ ............ -lmysqlclient ========================== Module: zlib -- ............ --- ZLib Support enabled Compiled Version 1.2.2 Linked Version 1.2.2 ========================== ............ | no value safe_mode_gid | Off | Off safe_mode_include_dir | no value | no value safe_mode_exec_dir ............ ,popen,shell_exec,proc_open file_uploads | On | On include_path | .:/opt/php/lib/php | .:/opt/php/lib/ ............ | no value | no value sendmail_path | /usr/sbin/sendmail_r -t -i -fwebmaster@soundamental.org | / ............ /sbin/sendmail -t -i SMTP | localhost | localhost ............ | Master Value max_execution_time | 10 | 10 max_input_time | 10 | 10 upload_max_filesize | 48M | 48M ............ | 48M ========================== Page generated in 0.461 seconds - 16 queries in 0.009 seconds - ......
...... , so I restored everything with 1.2.1 and it worked fine. Then I followed ............ upgrade 1.3.0 directions. After running update.php, the following occurs: While ............ WHERE parent = '' ORDER BY pos" on 0 mySQL error: Unknown column 'thumb' in 'field list' ......
198
cpg1.4 miscellaneous / Re: Error when registering new user
« by emsbear on January 02, 2006, 07:35:41 pm »...... debug data: ---------------------- While executing query "INSERT INTO cpg_users (user_regdate, ............ , user_name, user_password, user_email, user_profile1, user_profile2, user_profile3, user_profile4, ............ ) VALUES (NOW(), 'YES', '', 'test33', 'test', 'testing@testing.com', '', '', '', '', '', '')" on 0 ............ error: Unknown column 'user_profile1' in 'field list' -- ......
...... I get this lovely message: Quote While executing query "select user_id as id, user_password as ............ .cpg1410_users where user_id=0" on Resource id #5 mySQL error: Unknown column 'user_id' in 'field list' ............ searched the forums and couldn't find any answers that made sense to me. Any step-by- ............ , Coppermine For Dummies help would be wonderful. ......
200
cpg1.1d PHPnuke Support (deprecated) / Ok...
« by cityhunter on November 20, 2003, 01:59:08 pm »...... is the Link of the author of this VKP. http://www.phpnuke- ............ .de/index.html I dont want to put my url in Public now ............ . When i try to change it to "registered" coppermine comes up with a Bunch of Errors: --- There was ............ error while processing a database query. While ............ = '2', user_from = '', user_interests = '', user_website = '', user_occ= ............ '' WHERE uid = '8'" mySQL error: Unknown column 'user_interests' in 'field ............ solved: added the required tables to nuke_users instead of the installation cpg_users...what a mess] ............ It really doesnt look so good. I wished coppermine would create a own table for the necessary ............ User-Infos instead of using the nuke table for this... ......
201
cpg1.4 upgrading / Re: upgrade issue 1.3.3 to latest stable / Fatal Error
« by gateway on January 26, 2006, 09:58:00 pm »...... everything seems ok in the config.. .. the debug out put is ............ up now i didnt do a refresh but here is what index.php says Code: [Select] While executing query ............ , content, player FROM cpg133_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
202
cpg1.4 upgrading / Re: 1.3.3 to 1.4.9 Upgrade HELP!
« by DangerousTacos on August 28, 2006, 03:23:41 am »...... now get a fatal error: While executing query "SELECT extension, mime, ............ , player FROM cpg133_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
203
cpg1.3 Installation & Setup / Re: update cpg1.2.1 to cpg1.3.2 failed
« by Ciccio on August 31, 2004, 11:22:43 pm »...... that was my fault, just installed the phpMyAdmin thing and here is the error ............ got after putting debub_mode = 1 Fatal error : There was an error ............ processing a database query. While executing query "SELECT ............ (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 cpg11d_usergroups WHERE group_id in (3)" on 0 mySQL error: Unknown column ' ............ ' in 'field list' I hope that this is what you meant, ............ thanks in advance ......
...... executing query "UPDATE cpg133_users SET user_name = 'test' ............ , user_email = 'carin@caringlaser.com', user_active = 'YES', user_group ............ = '2', user_profile1 = 'USA', user_profile2 = 'Team 1', user_profile3 = ............ = '', user_profile6 = '', user_group_list = '', user_password = 'test1' WHERE user_id = '16' ............ " on 0 mySQL error: Unknown column 'user_profile1' in 'field ......
205
cpg1.3.x Support / Re: > 1k users --> very slow
« by russian_knight on July 01, 2004, 03:45:40 pm »...... , but i`v got another error. I don`t know is it linked with previous... On ............ "My profile" i get: There was an error while processing a database query. While ............ ) as user_regdate, group_name, user_location, user_interests, user_website, user_occupation, ............ as disk_usage, group_quota FROM cpg11d_users AS u INNER JOIN cpg11d_usergroups AS g ON user_group = ............ LEFT JOIN cpg11d_pictures AS p ON p.owner_id = u.user_id ............ user_id ='1' GROUP BY user_id " on 0 mySQL error: Unknown column 'user_location' in 'field ............ ' File: /var/www/html/photo/include/functions.inc.php - Line: 110 ......
206
cpg1.4 upgrading / Re: Fatal error: Call to a member function on a non-object
« by rissa on January 13, 2006, 06:03:37 am »...... , I just updated coppermine to 1.4.3 and I have my photos saved, but as I go ............ the gallery I now get this error... While executing query "SELECT extension, mime, ............ content, player FROM cpg135_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
...... , i m hurrying. ok. i followed the flash instructions. and i ............ this: While executing query "SELECT extension, mime, content, player ............ cpg133_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' i ............ lost again... cpg_133 is the folder in wich is installed ............ gallery. also, the beginning name of the table (!?) ......
208
cpg1.3.x Support / Re: "There was an error while processing a database query" involving users
« by omaetoy on August 14, 2005, 09:59:32 pm »...... when I try to modify a user: Quote While executing query "UPDATE cpg133_users SET user_name ............ = '2', user_location = '', user_interests = '', user_website = '', ............ = '', user_group_list = '' WHERE user_id = '8'" on 0 mySQL error: ............ column 'user_location' in 'field list' File: /home/ ............ /omaetoy/cpg133/include/functions.inc.php - Line: 105 I get the ............ error when a new user tries to register. Is there more ............ I need to provide? Please help in any way possible. ......
209
cpg1.4 upgrading / Re: I need help to connect database
« by Rana on December 23, 2007, 12:43:42 am »...... did as you said Fatal error : . While executing query "SELECT extension, ............ , content, player FROM cpg135_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
210
Looking for Freelancers / Paid help / Re: Mods Needed: Poster Desc. Editing, Comment deletion, Comment Blocking, and more.
« by pgt96drvr on February 07, 2005, 04:43:11 pm »...... was an error while processing a database query. While ............ WHERE pid = '372' LIMIT 1" on 0 mySQL error: Unknown column 'canrate' in 'field list' ............ : Constant SMILIES_PHP already defined in /hsphere/local/home/pgt96drv/eq2faces.com/ ............ /include/smilies.inc.php on line 20 ......