- April 27, 2024, 02:19:56 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
121
cpg1.3 (BBS) Integration / Bridging / IPB 2.0.4 : Ecard function doesn´t work
« by DaxMan on September 03, 2005, 10:06:28 pm »...... , Im trying to send Ecard but it fails. Before the ............ on IPB 2.0.4 it worked. Im importing usergroups from my Data Base and i changed in ............ . " " . "WHERE id='$cookie_uid' AND member_login_key='$cookie_pass'"; and now the Ecard function ............ ´t work Here is the error message: While executing query "SELECT name as ............ , mgroup, email as user_email, joined as user_regdate, location as user_location, ............ as user_interests, website as user_website FROM `forum`. ............ WHERE id = '1'" on 0 mySQL error: unknown column 'location' i field list ............ > 4 [3] => 4 [group_id] => 4 [4] => Admin [group_name] => Admin [5] => 100024 [ ............ ] => 100024 [6] => 0 [has_admin_access] => 1 [7] => 1 [can_rate_pictures] ............ `forum`.ibf_members WHERE id='1' AND member_login_key='**************' [2] => SELECT * FROM ............ name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, ............ as user_interests, website as user_website FROM `forum`. ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 4.3.4 - OK --- ............ --------------- mySQL version: 4.0.17-max-debug ------------------ ............ doesn't exist ========================== Module: mysql ------------------ Active Persistent Links 0 ............ Links 1 Client API version 3.23.49 ================= ............ --- 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 ............ | no value | no value file_uploads | On | On include_path | .;c:\php4\pear | .;c:\php4\pear ............ | Master Value max_execution_time | 30 | 30 max_input_time | 60 | 60 upload_max_filesize | 5M | 5M ............ 8M | 8M ========================== Page generated in 0.151 seconds - 6 queries in 0.01 seconds - Album ......
...... upgraded and now I get this error when I try to upload a pic While executing query ............ "INSERT INTO cpg_pictures (pid, aid, filepath, ............ ', '', '67.81.160.73', '67.81.160.73', '0')" on 0 mySQL error: Unknown column 'position' in 'field list' ............ : /home/djphilly/public_html/creamy_images/include/functions.inc.php - Line: 248 how can I ............ this. Thanks in advance. Rob ......
123
cpg1.4 upload / Critical Error - There was an error while processing a database query
« by furious fantasy on May 01, 2007, 11:01:42 pm »...... but when I assign it to a album I get hit with an error message. I ran it in debug mode and got this ............ While executing query "INSERT INTO cpg_pictures (aid, filepath, ............ '', '', '68.98.217.7', '68.98.217.7', '0')" on 0 mySQL error: Unknown column 'position' in 'field list' ......
124
cpg1.2 PHPnuke/Postnuke Support / upgrade error: Unknown column 'catname' in 'fieldlist'
« by marlloyd on December 11, 2003, 03:28:08 pm »...... sql error is: mySQL error: Unknown column ' ............ ' in 'field list' ......
125
cpg1.4 upgrading / Problems with upgrading from cpg1.3.2
« by AlcaDalca on July 17, 2006, 09:29:05 am »...... , I havent found a similar topic with the seach engine...yesterday i tired o upgrade from my older 1.3. ............ my gallery. the update.php told me, that everything is fine, but im experiencing problems. I only ............ the following message when i go to my domain: Fatal error : . ............ executing query "SELECT extension, mime, content, player ............ cpg132_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ............ manually import the old 1.3.2 database to a fresh installed 1.4.8, but I found out, that some data ............ have changed in the tables. Is there a db converting tool from 1. ............ ? Or shall I roll back my last backup and try again? What could be wrong that the upgrade failed? ......
126
cpg1.3 (BBS) Integration / Bridging / Compatibility with punbb 1.2.5
« by rajek on April 24, 2005, 05:02:01 am »...... 'have tried to install cpg but ... Code: [Select] While executing ............ ='847da2d12b1718da1400dc7bd928d213'" on 0 mySQL error: Unknown column 'status' in 'field list' Is ......
127
cpg1.4 miscellaneous / Fatal error: Please Help
« by 89ravenclaw on August 22, 2007, 07:30:00 am »...... i got to the index.php of my galleries i get this error message ............ error: While executing query "SELECT extension, mime, ............ , player FROM cpg1411_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
128
cpg1.4 upgrading / fatal error after updating from 1.3.x to 1.4.2 :(
« by NaRvA on November 28, 2005, 11:14:13 am »...... after update i got blank page with just "Fatal error:" message when trying to reach my gallery i did ............ update steps from manual after manually enabling debug mode i got this: "While executing query " ............ , content, player FROM cpg132_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' " ......
...... someone is trying to regiester on my site it says: "There was an ............ while processing a database query." code: While executing query ............ "INSERT INTO cpg130_users (user_regdate, user_active, ............ , user_password, user_email, user_location, user_interests, user_website, user_occupation) VALUES ( ............ , 'adas@yahoo.com', '', '', '', 'Student' )" on 0 mySQL error: Unknown column 'user_location' in 'field ............ ' And this is when I (admin) is trying to add a user: There was an error ............ processing a database query code: While executing query " ............ = 'bla', user_email = 'lars@linsson.com', user_active = 'YES', user_group ............ = '2', user_location = 'bla', user_interests = 'bla ', user_website = 'bla', ............ = 'bla', user_group_list = '', user_password = 'bla' WHERE user_id = ' ............ '" on 0 mySQL error: Unknown column 'user_location' in 'field ............ ' and under that it says: File: /home/virtual/linsson.com/public_html/2.lars/include/functions.inc. ............ - Line: 110 debug: USER: ------------------ Array ( ............ [user_active] => YES [user_name] => LarsLindqvist [user_password] => ******** [ ............ ] => 2004-08-09 15:54:52 [user_group_list] => [user_email] => [user_profile3] => ............ .linsson.com [user_profile1] => Nyköping, SWEDEN ............ ] => [disk_max] => 10000000 [disk_min] => 10000000 [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 ............ ] => 1 [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 cpg130_usergroups WHERE group_id in (1) [3] => SELECT group_name FROM ............ = 'bla', user_email = 'lars@linsson.com', user_active = 'YES', user_group ............ = '2', user_location = 'bla', user_interests = 'bla ', user_website = 'bla', ............ = 'bla', user_group_list = '', user_password = 'bla' WHERE user_id = ' ............ ] => YES [user_group] => 2 [group_list] => Array ( => 2 ) ............ [user_email] => lars@linsson.com [user_location] => bla [ ............ ] => bla ) ========================== VERSION INFO : ------------------ PHP version: 4.3.4 - OK --- ............ --------------- mySQL version: 4.0.18-log ========================== ............ compatible) FreeType Support enabled FreeType Linkage with freetype GIF Read Support enabled JPG ............ enabled ========================== Module: mysql ------------------ Active Persistent Links 0 ............ Links 1 Client API version 4.0.18 MYSQL_MODULE_TYPE ............ MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/ ............ /mysql/include/mysql MYSQL_LIBS -L/usr/local/mysql/lib/ ............ -lmysqlclient ========================== Module: zlib -- ............ --- 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 ............ ,chown,chgrp,chmod,touch file_uploads | On | On include_path | .:/usr/local/lib/php | .:/usr/local/ ............ /php open_basedir | /home/virtual/linsson.com:/home/virtual/_tmp | no value ============ ............ Value | Master Value sendmail_from | webmaster@linsson.com | no value sendmail_path | /usr/sbin/ ............ -t -i -f webmaster@linsson.com | /usr/sbin/sendmail -t -i SMTP | ............ | Master Value max_execution_time | 30 | 30 max_input_time | 60 | 60 upload_max_filesize | 6M | 6M ............ 8M | 8M ========================== Page generated in 0.094 seconds - 8 queries in 0.008 seconds - ......
130
cpg1.2 PHPnuke/Postnuke Support / Database error after upgrade from 1.1 -> 1.3
« by cookie-monster on June 28, 2005, 02:39:03 am »...... reading the instructions i updated my standalone version ............ 1.1 to 1.3 did the install etc (cant remember wot happened then) but ............ i keep getting the following error Code: [Select] While ............ WHERE parent = '' ORDER BY pos" on 0 mySQL error: Unknown column 'catname' in 'field list' ............ : modules/coppermine/include/functions.inc.php - Line: 101 Ive ............ searching the forums with no luck. I also have a full ............ of the old one but im hoping its some stupid mistake that is easily corrected. ............ If you need anymore info let me know Thanx in ......
...... one and upload over the other files and delete install.lock. She told me that she had done this a ............ the manual and I trusted her and I got database errors. Is there a way to fix it? The database seems to ............ intact. I put the gallery in debug mode and got ............ errors: While executing query "SELECT cid, name, ............ WHERE parent = '' ORDER BY pos" on 0 mySQL error: Unknown column 'thumb' in 'field list' ............ /virtual/site9/fst/var/www/html/hilary/pictures/include/functions.inc.php - Line: 105 http://www. ............ .org/hilary/pictures/index.php Can anybody help me or would I have to ............ the entire thing? :-( if I have to, I'll cry lol. ......
...... by Stramm. Unfortunately I do receive a "Fatal error": Quote While executing query "SELECT u.user_id ............ password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS ............ +100 AS group_id FROM `db34341`.shoots_users AS u INNER JOIN `db34341`.shoots_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 ............ I do wrong? What do I have to change? Thank you in advance, ......
133
cpg1.4.x Français (French) / erreur critique après upgrade de version 1.1 à version 1.4.5
« by sam-p2m on May 17, 2006, 03:03:53 pm »...... et lancé update.php pour mettre à jour la bdd maintenant quand j'essaye d'aller dans les albums j' ............ Quote While executing query "SELECT user_id as user_id,user_name as ............ ,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as ............ ) as gallery_pid FROM cpg11d_albums AS a INNER JOIN `aufildescroix2`.cpg11d_users as u on u. ............ = a.category - 10000 INNER JOIN cpg11d_pictures AS p ON p.aid = a.aid ............ BY category ORDER BY category LIMIT 0, 12 " on 0 mySQL error: Unknown column 'galleryicon' in 'field ............ Fichier: /mnt/111/free.fr/0/2/aufildescroix2/include/functions.inc.php - Ligne: 248 sauriez ......
134
cpg1.3 (BBS) Integration / Bridging / Unknown column 'location' in 'field list'
« by zacoo on March 12, 2005, 01:41:18 pm »...... logged in as an testuser and created an useralbum in ............ . Then, logged as an admin, I couldn't open the album I created earlier. ............ There was an error while processing a database query. While ............ name as user_name, mgroup, email as user_email, joined as user_regdate, location as user_location, ............ as user_interests, website as user_website FROM ` ............ `.ibf_members WHERE id = '7'" on 0 mySQL error: Unknown column 'location' in 'field list' ............ cpg132/include/functions.inc.php - Line: 105 Anyone has ............ idea? I'm using invisionboard 2.x and a bridged cpg 132. ......
135
Mods: Mod packs / Re: Mod Pack: Watermark, better thumbs, avatar, buddy, PM, notification
« by celeritycat on November 30, 2005, 07:46:55 pm »...... added the MySQL query and replaced the files from the ............ , and when I try to go to my profile using theme classic I recieve this error... Quote ............ executing query "SELECT auto_subscribe_post, ............ , enable_admin_email, user_pmsmail, user_name, user_email, ............ (user_regdate) as user_regdate, group_name, user_profile1, user_profile2, user_profile3, user_profile4, ............ , user_profile6, user_group_list, COUNT(pid) as pic_count, ROUND(SUM( ............ ) as disk_usage, group_quota FROM cpg_users AS u INNER JOIN cpg_usergroups AS g ON user_group = ............ LEFT JOIN cpg_pictures AS p ON p.owner_id = u.user_id WHERE ............ ='1' GROUP BY user_id " on 0 mySQL error: Unknown column 'enable_admin_email' in ' ............ list' Here is the debug info... Quote USER: ----- ............ => 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 [ ............ ; (0.003s) [1] => select * from cpg_plugins order by priority asc; (0.004s) [2] => ............ from `thevp_coppermine1`.cpg_sessions where time<1133371611 and ............ =0; (0.001s) [3] => delete from `thevp_coppermine1`.cpg_sessions where time<1132165611; (0s) [ ............ ] => select user_id from `thevp_coppermine1`.cpg_sessions where session_id=md5(" ............ id, user_password as password from `thevp_coppermine1`.cpg_users where user_id=1 (0.001s) [6] => ............ , u.user_group+100 AS group_id FROM `thevp_coppermine1`.cpg_users AS u INNER JOIN `thevp_coppermine1`. ............ .user_id='1' (0.002s) [7] => SELECT user_group_list FROM `thevp_coppermine1`.cpg_users AS u WHERE ............ ='1' and user_group_list <> ''; (0.001s) [8] => 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) (0.002s) [9] => SELECT group_name FROM ............ = 1 (0.001s) [10] => update `thevp_coppermine1`.cpg_sessions set time='1133375211' where ............ , auto_subscribe_comment, enable_admin_email, user_pmsmail, user_name, user_email, ............ (user_regdate) as user_regdate, group_name, user_profile1, user_profile2, user_profile3, user_profile4, ............ , user_profile6, user_group_list, COUNT(pid) as pic_count, ROUND(SUM( ............ ) as disk_usage, group_quota FROM cpg_users AS u INNER JOIN cpg_usergroups AS g ON user_group = ............ LEFT JOIN cpg_pictures AS p ON p.owner_id = u.user_id WHERE ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 4.4.1 - OK --- ............ --------------- mySQL version: 4.1.15-log ------------------ Coppermine ............ (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support: 1 GIF Read ............ Support: ========================== Module: mysql ------------------ MySQL Supportenabled Active ............ Links 0 Active Links 1 Client API version 4.1.11 ............ external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/ ............ /include/mysql MYSQL_LIBS -L/usr/local/lib/mysql - ............ --- 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 ............ | no value | no value file_uploads | On | On include_path | .:/usr/local/php4 | .:/usr/local/php4 ............ .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 | 60 | 60 upload_max_filesize | 2M | 2M ............ 8M | 8M ========================== Page generated in 0.281 seconds - 17 queries in 0.026 seconds - ............ set : ; Meta set: ; Can you please explain to me what I did wrong? ......
136
cpg1.4 cpmFetch by vuud / Re: CpmFetch - Embedding in templates (SMF, Wordpress, PHPBB, etc, ...)
« by dlkbailey on February 25, 2006, 05:37:43 pm »...... .php That should fix what ails you. The database in cpg changed between 1.3 and 1.4 I just ............ cpmfetch 1.6.2 and I get the following error on the test page " Unknown column 'u. ............ ' in 'field list' Warning: mysql_fetch_assoc(): ............ argument is not a valid MySQL result resource in /mounted-storage/home8/sub001/ ............ -TCLB/LN/cpmfetch/cpmfetch_dao.php on line 710" I searched the forum for this problem and ............ where there was the same problem. So I did as instructed from that post and read the release notes. ............ The release notes said to comment out line 54 and un comment line 59. I commented line 54 ............ there insn't even a line 59. I am lost and I would really ......
137
cpg1.4 plugins / Re: cpmfetch for coppermine 1.4.4 ?
« by wydook66 on March 14, 2006, 07:27:39 pm »...... have to install cpmfetch, I have executer cftest.php and now ............ have this error in the page Unknown column 'u.user_website' in ' ............ list' Warning: mysql_fetch_assoc(): supplied argument ............ not a valid MySQL result resource in /home/www/ ............ /web/album/cpmfetch/cpmfetch_dao.php on line ......
138
Mods: Permissions / Re: Upload permission in albums on group basis
« by Rorge on March 12, 2007, 03:41:41 pm »...... for your help GauGau While executing query "UPDATE cpg1410_albums SET title=' ............ ', visibility='0', alb_password='', alb_password_hint='', keyword='', upload_group='112' WHERE aid='39' ............ LIMIT 1" on 0 mySQL error: Unknown column 'upload_group' in 'field ......
139
cpg1.3 Installation & Setup / Re: Fatal error : There was an error while processing a database query
« by med20 on July 12, 2004, 12:40:56 am »...... you very much, that finally pushed me in the right direction. After ............ that modification I got the same errors with: 'custom_user_upload' 'num_file_upload' ' ............ ' I added each field with the same specs then the template came up ............ WHERE parent = '' ORDER BY pos" on 0 mySQL error: Unknown column 'thumb' in 'field list' ............ I added the field 'thumb' to cpg11d_categroies with int(11), not ............ me wonder if I have the permissions wrong on the mysql database to keep the update script from adding ............ fields - and if there may be more that I could run into ............ . Like: Notice: Undefined index: user_group_list in /home/virtual/ ............ .com/cpg/include/init.inc.php on line ......
...... I can post here. This is what it says when trying to run in debug: While executing query "SELECT ............ , content, player FROM cpg132_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
141
cpg1.2 Standalone Support / There was an error while processing a database query
« by Oasis on November 17, 2003, 08:42:33 pm »...... from: "ojohn" mySQL error: Unknown column 'user_name' in 'field list' ............ Did you make changes to functions.inc.php? There shouldn't be a query for user_name It ............ 't exist in ......
142
cpg1.4 upgrading / Re: database query error after update
« by robobear on September 30, 2006, 12:33:09 am »...... executing query "INSERT INTO cpg_pictures (aid, filepath, ............ , position) VALUES ('24', 'Aug2006/', 'Rasputin_a.jpg', '60138', '94599', '648', '486', ' ............ '', '', 'YES', '', '', '', '', '', '', '0')" on 0 mySQL error: Unknown column 'position' in 'field list' ............ : ***/testcoppermine/include/functions.inc.php - Line: 249 ......
...... that and this is the message I get: While executing query "SELECT extension, mime, content, player ............ cpg_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
...... a few cpg133_whatever why is that? this is the error now While executing query "SELECT extension, mime, ............ content, player FROM cpg133_filetypes;" on 0 mySQL error: Unknown column 'player' in 'field list' ......
145
cpg1.4 miscellaneous / Re: How do i include last addations in...
« by davelu on February 13, 2006, 01:16:47 am »...... ! however i ran into someproblems when i tired ther example. here's ............ error message it gave me. I passed the test though. ............ column 'u.user_website' in 'field list' Warning: ............ (): supplied argument is not a valid MySQL result resource in /var/www/html/cpmfetch/ ............ .php on line 710 Unknown column 'u.user_website' in 'field ............ ' Warning: mysql_fetch_assoc(): supplied argument is not a ............ MySQL result resource in /var/www/html/cpmfetch/ ............ .php on line 710 ......
146
cpg1.4.x Français (French) / Re: Erreur critique Il y eu une erreur lors de l'exécution de la requête.
« by François Keller on March 15, 2009, 08:41:05 am »...... mySQL error: Unknown column 'u.avatar_url' in 'field ............ ? parce que je l'ai fait pour toi et ça marche maintenant... ......
147
cpg1.4 plugin contributions / Re: Final_Extract v.2.3 with usergroup settings by admin panel
« by aravot on October 07, 2006, 10:39:34 pm »...... if I am not providing a link, I am testing it on a local installation ............ I apply it to my live site. Here is debug error. Quote While executing query "SELECT home,login, ............ ,upload_pic,album_list,lastup,lastcom,topn,toprated,favpics,search, ............ FROM cpg146_final_extract_config WHERE Group_Id=1" on 0 mySQL ............ : Unknown column 'logout' in 'field list' Quote File: C:\ ............ \www\cpg\include\functions.inc.php - Line: 249 Code: [ ............ - Array ( [user_id] => 1 [user_name] => admin [groups] => Array ( [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] => 0 ............ ] => 0 [group_name] => Administrators [upload_form_config] => 3 [ ............ ; (0.001s) [1] => select * from cpg146_plugins order by priority asc; (0s) [2] => delete ............ +100 AS group_id FROM `cpg`.cpg146_users AS u INNER JOIN `cpg`.cpg146_usergroups AS g ON u. ............ u.user_id='1' (0s) [7] => SELECT user_group_list FROM `cpg`.cpg146_users AS u WHERE user_id='1' ............ 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) (0s) [9] => SELECT group_name FROM ............ = 1 (0.001s) [12] => DELETE FROM cpg146_mod_online WHERE last_action < NOW() - INTERVAL 10 MINUTE ( ............ ) [13] => REPLACE INTO cpg146_mod_online (user_id, user_name, user_ip, ............ ) VALUES ('1', 'cpgadmin', '127.0.0.1', NOW()) (0.071s) [14] => SELECT ............ ,login,my_gallery,upload_pic,album_list,lastup,lastcom, ............ ,toprated,favpics,search,logout FROM cpg146_final_extract_config WHERE Group_Id=1 (0.001s) [ ............ ---- Array ( ) ========================== VERSION INFO : ------------------ PHP version: 5.1.6 - OK --- ............ --------------- mySQL version: 5.0.24a-community-nt ------------------ ............ (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support: 1 GIF Read ............ Support: ========================== Module: mysql ------------------ MySQL Supportenabled Active ............ Links 0 Active Links 1 Client API version 5.0.24a = ............ 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 | .;C:\php5\pear | .;C:\php5\pear ............ | Master Value max_execution_time | 30 | 30 max_input_time | 60 | 60 upload_max_filesize | 32M | 32M ............ | 32M ========================== Page generated in 0.209 seconds - 16 queries in 0.077 seconds - ......
148
cpg1.3 Permissions & Access Rights / Re: access and permissions
« by asphyxiia on December 13, 2005, 02:06:03 am »...... , i upgraded. i guess i can try it... where do i find that code i have to change? they get the form ............ fill out, the location and website fields are there unlike the person in this thread. its ............ when they hit the final button at the bottom to register they get this ............ Critical error There was an error while processing a database ............ . While executing query "INSERT INTO cpg_users (user_regdate, ............ , user_password, user_email, user_location, user_interests, user_website, user_occupation) VALUES ( ............ 'pyrogenetic@hotmail.com', '', '', '', '' )" on 0 mySQL error: Unknown column 'user_location' in 'field ............ ' File: /data/home/asphyxii/public_html/pics/include/functions.inc.php - Line: 105 is it in ............ functions.inc.php?? ack im so confused.. i dont even think i ............ what im talking about / ......
149
cpg1.3 Installation & Setup / Re: cant upgrade from 1.2.1 to 1.3
« by jakobl on July 02, 2004, 09:02:21 am »...... to open this thread again! I seem to have the same problem when updating to ............ .3.0 (stable). I get exactly the same error: There was an error while processing a database ............ . While executing query "SELECT cid, name, description, thumb FROM ............ WHERE parent = '' ORDER BY pos" on 0 mySQL error: Unknown column 'thumb' in 'field list' My ............ structure is looking like this (please see attachment): thus I am ............ the thumb-field. The Mysql user has all permissions. You can ............ at jati.dk/coppermine1.3.0/ for further info. Any suggestions? [ ............ deleted by admin] ......
150
Mods: Bridging/Integration / Re: integrating Viper Guestbook X1
« by gangavalli on June 26, 2006, 11:00:59 pm »...... guestbook is not standalone. I installed using the viper install php file only. I ............ asked the guestbook author about the error. This is the thread: http://www.danskcinders.com/ ............ but there is another problem now. after posting the content, there is an error: Code: [Select] ............ following MySQL query produced an error: select ............ , ENTRYSENT from VGB_ADMIN where COMMENTEMAIL != '' 1054: Unknown column ' ............ ' in 'field list' how can i sort this? ......