1

cpg1.4.x Français (French) / ERREUR CRITIQUE: functions.inc.php . Besoin d'aide SVP.

« by maileaudy on January 20, 2012, 01:38:53 pm »

......  ça n'a pas marché, dans la panique j'ai donc réinstallé les fichiers coppermine que j'avais  ............  1.4.  Ma galerie a donc récupéré son apparence initiale mais il reste une erreur :-(  Les diffé ............ ".  Le message suivant apparait:   While executing query 'SELECT pid, filepath, filename,  ............ , caption,hits,owner_id,owner_name from Copperminepictures WHERE ((aid='149' ) ) ORDER BY  ............  DESC LIMIT 0 ,20' in include/functions.inc.php on line 1001  mySQL  ............ : Unknown column 'owner_name' in 'field list'  Fichier: / ............ /31/d291689598/htdocs/Coppermine/include/functions.inc.php - Ligne: 264   Et  ............  un extrait du fichier php en question: functions.inc.php Ligne 264... Code: [Select] function  ............ ' || ($CONFIG['debug_mode'] === '2' && !GALLERY_ADMIN_MODE)) {  cpg_die(CRITICAL_ERROR, $ ............ ['database_query'], __FILE__, __LINE__);  } else {   $the_error  ............  cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);  } }  Et ligne 1001: Code: [Select]   ............  like '%$album_keyword%' $forbidden_set_string )";  } else {  $ ............  }   $approved = GALLERY_ADMIN_MODE ? '' : 'AND approved=\'YES\'';    ............ ']} WHERE ((aid='$album' $forbidden_set_string ) $keyword) $approved $ALBUM_SET";   ............ ($result);   if($select_columns != '*') $select_columns .= ', title, caption, ............ ';   $query = "SELECT $select_columns from {$CONFIG['TABLE_PICTURES']} WHERE ((aid='$ ............ ' $forbidden_set_string ) $keyword) $approved $ALBUM_SET ORDER BY $ ............ );  }    $rowset = CPGPluginAPI::filter('thumb_caption_regular',$rowset);    ......

2

cpg1.5 miscellaneous / Re: Error at Visitors can upload files

« by Silur3D on June 04, 2015, 12:27:44 pm »

...... :  •Jun 03, 2015 at 05:38 PM - While executing query 'INSERT INTO cpg15x_pictures (aid,  ............ , user10, user11, user12, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('1', 'userpics/10001/', ' ............ ,'2', '', '', '','', '', '', '', '', '', '0', '')' in include\picmgmt.inc.php on line 181 the following  ............  was encountered:   Unknown column 'user5' in 'field list'   i have installed  ............  "more_fields_mode" ......

3

cpg1.4.x Español (Spanish) / Re: Ayuda !! ( include/functions.inc.php - Línea: 250 )

« by Fercho on September 14, 2010, 12:26:59 am »

......  por dormilon.  Acá esta el enlace http://www.infiernomurguero.com.ar/galeria/  Subi la ultima  ............  y me sigue tirando error  While executing query "INSERT INTO cpg14x_pictures (aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('37', 'userpics/', 'Imagen_016~8.jpg', ' ............ .116', '186.18.172.116', '0')" on 0  mySQL error: Unknown column 'owner_name' in 'field list'   Cuando  ............  quedaron de una versión desactualizada de Coppermine: 0 Versiones de archivos desactualizadas:  ......

4

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  ............  is the SQL error message, followed by the debug info:  While executing query "INSERT INTO  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('20', 'userpics/', 'egypt224.jpg', ' ............ , '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,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('20', 'userpics/', 'egypt224.jpg', ' ............ , '480009', '1360', '2048', '1176280572', '1', 'Admin','', '', '', 'YES', '', '', '', '', '125.239.206. ............ ] => picture )  ========================== VERSION INFO : ------------------ PHP version: 4.4.4 - OK --- ............ : 4.1.21-standard-log ------------------ Coppermine version: 1.4.10(stable) ========================= ............  (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support:  GIF Read  ............ ---------- MySQL Supportenabled Active Persistent Links 0  Active Links 1  Client API version 4.1.21   ............   MYSQL_SOCKET /var/lib/mysql/mysql.sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/lib - ............ - 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  ......

5

cpg1.4 upload / Upload file error

« by terencef on April 09, 2006, 03:53:16 pm »

...... 's my debug info...  While executing query "INSERT INTO  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '5', 'userpics/10001/', 'Pic~4.jpg',  ............ .151', '65.23.231.151', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  Can someone  ......

6

cpg1.4.x Français (French) / Différence de mise en page entre IE et Netscape

« by Roseline on April 03, 2006, 03:43:00 pm »

...... égories qui se sont mis au centre de ma page d'index sous IE, alors que sous Netscape tout est à  ............ : #ECE3EF ;  color : #000000;  padding-top: 3px;  padding-right: 10px;   ............ -bottom: 3px;  padding-left: 10px; vertical-align : left; j'ai ajouté ç ............  change rien  }  http://aliasfile.free.fr/galerie/index.php   sinon, ce problème-ci est résolu :  je n' ............  de la requête   en mode debug : "While executing query "INSERT INTO cpg130_pictures (aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('90', 'userpics/10001/', '502_01.jpg', ' ............ ', '73040', '624', '352', '1144570584', '1', 'Roseline','', '', '', 'YES', '', '', '', '', '82.126.40. ............ ', '82.126.40.158', '0')" on 0"  mySQL error: Unknown column 'position' in 'field list'    Fichier: / ............ /www/sdc/e/4/aliasfile/galerie/include/functions.inc.php - Ligne: 248   ainsi que  ............ .php    RESOLU : j'ai refait update.php et maintenant ça marche   ......

7

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  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '8', 'userpics/10001/', 'adverts~0. ............ .85.50', '165.247.85.50', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'     This was  ............  user:  Quote  There was an error while processing a database query.  While executing query "UPDATE  ............  SET user_name = 'testman', user_email = 'pacos@gamingextremes.us', user_active = 'YES', user_group = ' ............  = '', user_profile6 = '', user_group_list = '', user_password = 'testpass' WHERE user_id = ' ............ '" on 0  mySQL error: Unknown column 'user_profile1' in 'field list'     I have  ............  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! ......

8

cpg1.4 upload / File uploads, but error when assigning category

« by PaveFE on January 01, 2006, 02:38:32 am »

...... ,  I've seen similar error messages, but here's mine:  While executing query "INSERT INTO  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '15', 'userpics/10001/', ' ............ .184', '68.84.159.184', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  Any solutions?  ......

9

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 cpg14x_pictures (pid, aid,  ............ , user3, user4, user5, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '4', 'userpics/10001/', 'MVC-013F~2. ............ ', '269494', '640', '480', '1198168396', '1', 'admin','', '', '', 'YES', 'LOC', 'EVENT', 'NAMES', ' ............ .83.34', '38.105.83.34', '0')" on 0  mySQL error: Unknown column 'user5' in 'field list'   I've attached  ............  debug info (it was to long to include)  I've also attached  ............  admin file with the changes (did I put it in wrong?)   ......

10

cpg1.4 upload / Upload Issue

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

...... ,  I was posting by "upload file" under my admin login to an  ............  on my coppermine photo gallery and got the error below. I got  ............  error being logged in under "admin" > clicking on upload  ............  my computer > selected the file > clicked on continue > the file successfully uploaded > clicked on  ............  again and the error below appeared. Can anyone tell me  ............  I'm doing wrong or is it a Coppermine issue? Thanks in  ............  :::smiles:::  While executing query "INSERT INTO cpg_pictures (pid, aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '6', 'userpics/10001/', 'scan0001~1. ............ ', '457867', '1182', '788', '1160201768', '1', 'admin','', '', '', 'YES', '', '', '', '', '69.19.109.96' ............ , '69.19.109.96', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  ALSO, below is  ............  debug information:::::::::::::::::::::::: Code: [Select]  ............ - 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  [ ............  AS group_id FROM `scottcou_copp1`.cpg_users AS u INNER JOIN `scottcou_copp1`.cpg_usergroups AS g ON u. ............  u.user_id='1' (0s)  [6] => SELECT user_group_list FROM `scottcou_copp1`.cpg_users AS u WHERE  ............ ='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  ............  ORDER BY title (0s)  [15] => SELECT encoded_string FROM cpg_temp_data WHERE unique_ID = '3523c6d9' ( ............ )  [16] => UPDATE cpg_temp_data SET encoded_string = 'YTowOnt9' WHERE unique_ID = '3523c6d9' (0s)   ............  FROM cpg_albums WHERE aid='6' (0s)  [18] => INSERT INTO cpg_pictures (pid, aid, filepath,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '6', 'userpics/10001/', 'scan0001~1. ............ ', '457867', '1182', '788', '1160201768', '1', 'admin','', '', '', 'YES', '', '', '', '', '69.19.109.96' ............ - 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  [ ............  AS group_id FROM `scottcou_copp1`.cpg_users AS u INNER JOIN `scottcou_copp1`.cpg_usergroups AS g ON u. ............  u.user_id='1' (0s)  [6] => SELECT user_group_list FROM `scottcou_copp1`.cpg_users AS u WHERE  ............ ='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  ............  ORDER BY title (0s)  [15] => SELECT encoded_string FROM cpg_temp_data WHERE unique_ID = '3523c6d9' ( ............ )  [16] => UPDATE cpg_temp_data SET encoded_string = ' ............ =============== ========================== VERSION INFO : ------------------ PHP version: 4.4.2 - OK --- ............ : 4.1.21-standard-log ------------------ Coppermine version: 1.4.2(stable) ========================== ............  (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support:  GIF Read  ............ ---------- MySQL Supportenabled Active Persistent Links 0  Active Links 1  Client API version 4.1.21   ............   MYSQL_SOCKET /var/lib/mysql/mysql.sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/lib - ............ --- 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/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  ............  | 24M ========================== Page generated in 0.747 seconds - 18 queries in 0.001 seconds -  ............  Meta set: ; )  ========================== VERSION INFO : ------------------ PHP version: 4.4.2 - OK --- ............ : 4.1.21-standard-log ------------------ Coppermine version: 1.4.2(stable) ========================== ............  (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support:  GIF Read  ............ ---------- MySQL Supportenabled Active Persistent Links 0  Active Links 1  Client API version 4.1.21   ............   MYSQL_SOCKET /var/lib/mysql/mysql.sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/lib - ............ --- 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/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  ............  | 24M ========================== Page generated in 0.333 seconds - 24 queries in 0.029 seconds -  ............  Meta set: ; )  ========================== VERSION INFO : ------------------ PHP version: 4.4.2 - OK --- ............ : 4.1.21-standard-log ------------------ Coppermine version: 1.4.2(stable) ========================== ............  (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support:  GIF Read  ............ ---------- MySQL Supportenabled Active Persistent Links 0  Active Links 1  Client API version 4.1.21   ............   MYSQL_SOCKET /var/lib/mysql/mysql.sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/lib - ............ --- 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/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  ............  | 24M ========================== Page generated in 2.819 seconds - 20 queries in 0 seconds - Album  ......

11

cpg1.4 upload / Upload Error Message

« by marcia on March 06, 2006, 04:25:18 pm »

......  are unable to upload their files - the following error message occurs  While executing query " ............  INTO cpg_pictures (pid, aid, filepath, filename,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '2', 'userpics/10030/', 'kennedy1~0. ............  '324417', '1546', '1159', '1141658535', '30', 'Admin','test', '', '', 'YES', '', '', '', '', '67.70.18. ............ ', '67.70.18.66', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'   Can anyone  ......

12

cpg1.4 upload / Critical Error when uploading

« by PrinzII on February 07, 2006, 03:43:27 pm »

...... .4.2  Whenever I upload pictures, I get the following critical error:   While executing query "INSERT  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '8', 'userpics/10001/', ' ............ ', '150445', '436', '290', '1139322740', '1', 'PrinzII','Pic of me taken circa December 2005', '', '', ............ .51.59', '67.163.51.59', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  File: /home/ ............ /public_html/gallery/include/functions.inc.php - Line: 248   The strange  ............  is it looks as if it is accepting the picture but when it gets to the point where  ............  am selecting which category to place it in, that's when I get  ............  above message.  I will also double check all settings per the sticky. ......

13

cpg1.4 upload / Error uploading photos

« by solupine on June 17, 2006, 11:09:06 pm »

......  am having a problem uploading photos to my site, both  ............  and if I try to batch add them. I don't think I ever changed any settings, so I am not sure  ............  it is doing this now. After I upload it says the photos  ............ , but when I click the next button to continue I get this error message:  --------------------- ............ ---- While executing query "INSERT INTO cpg_pictures (pid, aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '44', 'userpics/10001/', ' ............ .27.23', '69.255.27.23', '0')" on 0  mySQL error: Unknown column 'position' in 'field list' ---------------- ......

14

cpg1.4 upload / 'Position' in 'field list'??????????

« by thoxic on December 17, 2005, 07:35:41 pm »

......  one picture:    There was an error while processing a database query.  Code: [Select] While  ............  query "INSERT INTO cpg_pictures (pid, aid, filepath,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '44', 'userpics/10001/', 'thi1-avat. ............ .4.228', '200.148.4.228', '0')" on 0  mySQL error: Unknown column 'position' in 'field list' File: /=/=/=/=/ ............ /functions.inc.php - Line: 248  -----  Can someone help me?!  ......

15

cpg1.5 upload / Re: Critical Error When Uploading

« by Αndré on June 10, 2010, 04:21:41 pm »

......  from: BradInOKC on June 10, 2010, 03:32:38 pm  Nobody has any  ............ ?   This is not a hotline. We are just a small team, so please be patient.  ............   Quote  While executing query 'INSERT INTO cpg15x_pictures (aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('11', 'userpics/10002/', ' ............ ', '', '', '77.12.79.72', '77.12.79.72', '0', '')' in include/picmgmt.inc.php on line 165  mySQL error:  ............  column 'guest_token' in 'field list'   Please run update. ......

16

cpg1.4 cpmFetch by vuud / Re: CpmFetch 1.4 On... Displaying data and images from CPG on your website

« by MDkai on April 01, 2006, 06:34:38 pm »

......  a small hint:   I had the same problem like doktor K Quote   ............  installation seems correct so far, you should see a  ............  grid of thumbnails from your gallery Unknown column 'u.user_website' in 'field list' Warning:  ............  argument is not a valid MySQL result resource in /cpmfetch/cpmfetch/cpmfetch_dao.php on line 710    ............  reading gmc's tip i found the /* */ on a different  ............  (between the beta part)  I switched the position but got a parsing error.  After deleting the two / ......

17

cpg1.4 upgrading / error processing database querry

« by pixnj on July 11, 2006, 10:57:30 pm »

......  error when I try to upload a pic  While executing query "INSERT INTO cpg_pictures (pid, aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('', '32', 'userpics/10001/', 'pimphand~3. ............ .160.73', '67.81.160.73', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  File: /home/ ............ /public_html/creamy_images/include/functions.inc.php - Line: 248   how can I  ............  this. Thanks in advance.  Rob  ......

18

cpg1.4 JUpload by etienne_sf / Re: jUpload don't upload (session management

« by topkool on July 03, 2010, 08:11:53 am »

......  :   "Jul 03, 2010 at 07:09 AM - While executing query 'INSERT INTO cpg140_pictures (aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('121', 'userpics/10001/', ' ............ , '', '', 'YES', '', '', '', '', '', '', '0', '')' in include/picmgmt.inc.php on line 165 the following  ............  was encountered:  Unknown column 'guest_token' in 'field list'" ......

19

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 »

......  album I get hit with an error message. I ran it in debug mode and got this message   While executing  ............  "INSERT INTO cpg_pictures (aid, filepath, filename,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('26', 'userpics/', 'diamonbacks_07_dean~ ............ .217.7', '68.98.217.7', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  Any thoughts??  ......

20

cpg1.4 JUpload by etienne_sf / Re: Edit file properties problem after uploading

« by topkool on July 01, 2010, 09:17:34 am »

......  message:  Jul 01, 2010 at 08:16 AM - While executing query 'INSERT INTO cpg140_pictures (aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('121', 'userpics/10001/', ' ............ , '', '', 'YES', '', '', '', '', '', '', '0', '')' in include/picmgmt.inc.php on line 165 the following  ............  was encountered:  Unknown column 'guest_token' in 'field list' ......

21

cpg1.4 miscellaneous / Re: Database Error - Unknown column???

« by psylocke on January 14, 2010, 12:35:14 am »

......  even after the move. How can I add this missing field?  Quote  While executing query "INSERT  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('303', 'promotional_pics/test/', ' ............ ', '60622', '445', '295', '1263425171', '1', 'admin','', '', '', 'YES', '', '', '', '', '', '', '0')"  ............  0  mySQL error: Unknown column 'owner_name' in 'field list'    ......

22

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,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('24', 'Aug2006/', 'Rasputin_a.jpg', ' ............ , '', '', '', '', '', '', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  File: ***/ ............ /include/functions.inc.php - Line: 249  ......

23

cpg1.4 upgrading / Re: Critical erro - processing database query

« by LACA Rio on July 13, 2006, 09:23:36 pm »

......  for reply.  Here's the code:  While executing query "INSERT INTO cpg135_pictures (aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('3', 'userpics/10001/', '71~1.jpg', ' ............ .202', '201.51.163.202', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  ......

24

cpg1.4 upload / Re: Mysteriously Can't Add Photos

« by paperraven on April 12, 2006, 03:58:46 am »

...... 've done everything that that told me to do.. and it didn't fix  ............ . The debug did inform me that the actual MySQL error was:  mySQL  ............ : Unknown column 'position' in 'field list'  Should I go  ............  PHPMyAdmin and delete that column? I've no idea what to do.. ......

25

cpg1.4 upgrading / Re: There was an error while processing a database query

« by Invalid ID on October 19, 2006, 08:05:15 am »

......  for your reply. Following is the message I notice when I clicked to upload  ............  appreared at the bottom:  *************** /include/logger.inc.php   * Notice line 172:  ............  index: log_mode  * Notice line 164: Undefined  ............ : log_mode  /include/init.inc.php   * Notice line 223:  ............  index: enable_plugins  * Notice line 228:  ............  index: bridge_enable  /include/functions.inc.php    ............  * Notice line 395: Undefined index: time_offset  * Notice  ............  395: Undefined index: time_offset  /include/themes.inc.php    ............  * Notice line 1188: Undefined index: custom_header_path  *  ............  line 1336: Undefined index: home_target  * Notice  ............  1374: Undefined index: custom_lnk_url  * Notice line 1382:  ............  index: custom_lnk_url  * Notice line 1383:  ............  index: custom_lnk_name  * Notice line 1384:  ............  index: custom_lnk_name  * Notice line 1220:  ............  index: custom_footer_path  /upload.php   * Notice  ............  269: Undefined offset: 2  * Notice line 275: Undefined  ............ : 3  * Notice line 275: Undefined offset: 4 *************  After I  ............ , the message came:  ***********  /include/logger.inc.php   * Notice line 172:  ............  index: log_mode  /include/init.inc.php   * Notice  ............  223: Undefined index: enable_plugins  * Notice line 228:  ............  index: bridge_enable  /include/functions.inc.php    ............  * Notice line 395: Undefined index: time_offset  * Notice  ............  395: Undefined index: time_offset  /upload.php   * Notice  ............  1968: Undefined variable: file_failure_array  * Notice line  ............ : Undefined variable: URI_failure_array  * Notice line  ............ : Undefined variable: zip_failure_array  /include/themes. ............ .php   * Notice line 1188: Undefined index: custom_header_path  *  ............  line 1336: Undefined index: home_target  * Notice  ............  1374: Undefined index: custom_lnk_url  * Notice line 1382:  ............  index: custom_lnk_url  * Notice line 1383:  ............  index: custom_lnk_name  * Notice line 1384:  ............  index: custom_lnk_name  * Notice line 1220:  ............  index: custom_footer_path  ************  On the page  ............  I choose Album for Pics:  *********  /include/logger.inc.php   * Notice line 172:  ............  index: log_mode  /include/init.inc.php   * Notice  ............  223: Undefined index: enable_plugins  * Notice line 228:  ............  index: bridge_enable  /include/functions.inc.php    ............  * Notice line 395: Undefined index: time_offset  * Notice  ............  395: Undefined index: time_offset  * Notice line 2649:  ............  index: enable_help  * Notice line 2650: Undefined  ............ : enable_help  * Notice line 2672: Undefined variable: i  /include/picmgmt. ............ .php   * Notice line 170: Undefined variable: imageinfo  * Notice  ............  205: Undefined index: OS  /include/themes.inc.php   *  ............  line 1188: Undefined index: custom_header_path  *  ............  line 1336: Undefined index: home_target  * Notice  ............  1374: Undefined index: custom_lnk_url  * Notice line 1382:  ............  index: custom_lnk_url  * Notice line 1383:  ............  index: custom_lnk_name  * Notice line 1384:  ............  index: custom_lnk_name  * Notice line 1220:  ............  index: custom_footer_path  ************  And then...  ............  Code: [Select] There was an error while processing a database query.  While executing query "INSERT  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('20', 'userpics/', 'cowasaki~2.gif', ' ............ ', '273821', '375', '281', '1161237714', '1', 'Admin','', '', '', 'YES', '', '', '', '', '202.125.143. ............ ', '202.125.143.67', '0')" on 0  mySQL error: Unknown column 'position' in 'field list'  ......

26

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 --- ............ : 4.1.21-standard ------------------ Coppermine version: 1.4.8(stable) ========================== ............  (2.0.28 compatible) FreeType Support: 1 FreeType Linkage: with freetype T1Lib Support:  GIF Read  ............ ---------- MySQL Supportenabled Active Persistent Links 0  Active Links 1  Client API version 4.1.21   ............   MYSQL_SOCKET /var/lib/mysql/mysql.sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/lib - ............ - 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,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('192', 'uploads/test/', 'dug.jpg', ' ............ , '', '', '', '', '', '', '0')" on 0  mySQL error: Unknown column 'position' in 'field list' Any insight  ......

27

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.  ............  error:  Quote  There was an error while processing a database query. While executing query "INSERT  ............ , user4, user5, user6, pic_raw_ip, pic_hdr_ip, position) VALUES ('14', 'userpics/10001/', 'darkwing~6.jpg' ............ .167.8', '65.43.167.8', '0')" on 0  mySQL error: Unknown column 'user5' in 'field list'  [Edit GauGau] ............  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  ......

28

cpg1.4.x Deutsch (German) / Re: Fehlermeldung "Fatal Error"

« by JohnnyBolero on June 02, 2008, 09:06:39 pm »

...... , es hagelt weitere Fehlermeldungen in allen Bereichen der Galerie, ich habe allerdings  ............  nur ein back-up von users, usergroups & pictures  ............  'K10485sql1.cpg133_votes' doesn't exist ->noch ein table, der noch wieder rein muss Code: [Select]  ............  executing query "INSERT INTO cpg133_pictures (aid,  ............ , user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('552', '08-03-08limit-verlosung/', ' ............ , '', '', '', '', '', '', '0')" on 0  mySQL error: Unknown column 'position' in 'field list' also, was  ............  ich machen, ein komplettes back-up einspielen? leider 3 monate  ............ , außerdem noch vor dem update auf eine neuere CPG-Version oder die update.php ausführen? ......