Advanced search  

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

Pages: [1] 2 3 4 5 ... 7
1
cpg1.5 upgrading / mySQL error: Unknown column 'access_level' in 'field list'
« by Nookster on December 09, 2012, 01:44:53 am »

......  it is not working for me. I was on 1.4.19, successfully upgraded  ............  1.4.29. I tried to upgrade to 1.5.20 and am getting fatal errors. I've backed, restored the  ............ , and tried again half a dozen times. Each time, after I run  ............ .php, when I go the gallery I get a fatal error. I set debug_mode to 1 in cpg_config using mysql  ............  now I get the following error:  While executing query 'SELECT MAX( ............ ) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures)  ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS  ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval,  ............  FROM cpg_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 323   ............  error: Unknown column 'access_level' in 'field list'  ......
2
cpg1.4 cpmFetch by vuud / I need some help !
« by lazlo on August 18, 2011, 01:58:17 am »

......  the code working beautifully for years, we are getting the  ............  error message:   Unknown column 'p.owner_name' in............  list'  SELECT p.filepath AS pFilepath, p.filename AS  ............  pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS  ............ .keyword as aKeyword FROM cpg_pictures AS p LEFT JOIN cpg_albums AS a ON p.aid = a.aid LEFT JOIN  ............  p.ctime DESC LIMIT 0,10 [phpBB Debug] PHP Notice: in file /home7/davrodig/public_html/galleries/ ............ /cpmfetch_dao.php on line 1260: mysql_fetch_assoc(): supplied argument is  ............  a valid MySQL result resource [phpBB Debug] PHP Notice: in file  ............ /galleries/cpmfetch/cpmfetch_dao.php on line 1264: mysql_free_result(): supplied argument is  ............  a valid MySQL result resource  The site is here: http://www. ............ .com/imageforum/ Coppermine Gallery is here: http://www.davrodigitalonline. ............ /galleries/index.php Using Coppermine 1.4.19 cpmfetch 2.0 is  ......
3
cpg1.5 plugins / Need Help with cpg1.5 and joomla
« by extreme2211 on November 08, 2012, 02:53:50 am »

......  have install cpg1.5 and i uploaded cpmfetch to the same  ............  as i installed cpg when I run the install.php from  ............  i get an error   Unknown column 'p.owner_name' in 'field list'   ............  pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS  ............  as aKeyword FROM cpg15x_pictures AS p LEFT JOIN cpg15x_albums AS a ON p.aid = a.aid LEFT JOIN  ............  = "")) ORDER BY p.ctime DESC LIMIT 0,4  Warning: mysql_fetch_assoc(): supplied argument is not a  ............  MySQL result resource in /home2/techsonh/public_html/ ............ /photo/cpmfetch/cpmfetch_dao.php on line 1260  Warning: mysql_free_result(): supplied  ............  is not a valid MySQL result resource in /home2/techsonh/public_html/ ............ /photo/cpmfetch/cpmfetch_dao.php on line 1264     and I can not get an images on my site  ............  get this error when trying  Error opening the path to CpmFetch/ ......
4
cpg1.5 upgrading / Fatal error when upgrading
« by Arakikida on August 25, 2016, 08:00:36 pm »

......  ) from 1.4.x to the current version of Coppermine, but somehow I'm getting a fatal error now.   It  ............ :  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 333   ............  error: Unknown column 'access_level' in 'field list'  I' ............  where? I understand there has to be some issue in the bridge folder, but what exactly should I  ............  there?  Also how can I fix that MySQL error?  Please help.  Thx. ......

...... 've searched around some and don't see anything to resolve my issue. i restored my gallery to a  ............  and categories, but when you click the album an error "There was an error while processing a database  ............  up.. now im not sure if this has to do with me using the 1.5 newer coppermine on my old host and  ............  debug mode and this is what i got:  While executing query "SELECT pid, filepath, filename,  ............ , pheight, ctime, aid, keywords, votes, pic_rating, title, caption,hits,owner_id,owner_name from  ............ ' ) ) ORDER BY filename ASC LIMIT 0 ,40" on 0  mySQL error: Unknown column 'owner_name' in 'field list......
6
cpg1.4 upgrading / mySQL error: Unknown column 'player' in 'field list'
« by veralucero on September 12, 2006, 11:14:16 pm »

......  I get the following error when I try to navigate to my photo album  ............ ://www.allfamilyone.com/PhotoGallery/  While executing query "SELECT extension, mime, content, player  ............  cphoto_filetypes;" on 0  mySQL error: Unknown column 'player' in 'field list'  I  ............ /x2/ . THere was an automatic script that installed the scripts/dir/etc. I do not have an  ............ .php and when I check the config.inc.php file it looks okay. Looks like the software/ ............  are not in sync. Is there something I can do or is this  ............  that simplehost.com admins are supposed to take care of? It looks like  ......

......  1.3.3, yes, I have tried updating a test database of the same version, but it  ............  works.  I get the following error when I try to navigate to my photo album  ............  http://www.chicagobirds.com/photos  While executing query "SELECT extension, mime, content, player  ............  cphoto_filetypes;" on 0  mySQL error: Unknown column 'player' in 'field list'  ......
8
cpg1.5 upgrading / Fatal error (all over again)
« by roxana on December 18, 2010, 11:31:30 pm »

...... , I'm trying to follow the rules here, so please, I need help. ............  My gallery is down since I upgraded it. Here's debug info:  FATAL ERROR  ............   While executing query 'SELECT MAX(group_quota) as disk_max, MIN............ ) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX( ............ , 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 cpg149_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 309   ............  error: Unknown column 'upload_form_config' in 'field  ............  I have all done, updated and good, so why that error? I upgraded from 1.49. I'm not a coppermine  ......

......  ç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  ............ ($the_error) {  global $CONFIG,$lang_errors;    ............ ' || ($CONFIG['debug_mode'] === '2' && !GALLERY_ADMIN_MODE)) {  cpg_die(CRITICAL_ERROR, $ ............ ['database_query'], __FILE__, __LINE__);  } else {   $the_error  ............ .= "\n\nmySQL error: ".mysql_error()."\n";   $ ............  = "<br />".$lang_errors['database_query'].".<br /><br/>   ............  <form name=\"mysql\"><textarea rows=\"8\" cols=\"60\">". ............ ($the_error)."</textarea></form>";   cpg_die( ............ , $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";   ............  = cpg_db_query($query);  $nbEnr = mysql_fetch_array($result);  $count = $ ............ [0];  mysql_free_result($result);   if($ ............  != '*') $select_columns .= ', title, caption,hits,owner_id,owner_name';   ............  $query = "SELECT $select_columns from {$CONFIG['TABLE_PICTURES']} WHERE ((aid='$ ............ ' $forbidden_set_string ) $keyword) $approved $ALBUM_SET ORDER BY $ ............  = cpg_db_fetch_rowset($result);  mysql_free_result($result);  // Set  ............ );  }    $rowset = CPGPluginAPI::filter('thumb_caption_regular',$rowset);    ......
10
cpg1.4 cpmFetch by vuud / Re: cpmfetch setup help
« by vuud on May 29, 2006, 06:40:25 am »

......  buchananben on May 29, 2006, 05:51:40 am  I am trying to setup cpmfetch (latest version) with  ............  (latest version). I am getting the following error on the cftest.php page:   ............  column 'u.user_website' in 'field list' Warning:  ............ (): supplied argument is not a valid MySQL result resource in /gallery/cpmfetch/cpmfetch_dao. ............  on line 710  Does anyone know what is causing this or  ............  to fix it? I'm thinking that maybe it has something to do with the  ............  that I have bridging enabled to a punBB forum, since other than that  ............  is a completely standard coppermine install.   Thanks Ben    Read the instructions  ......
11
cpg1.4 cpmFetch by vuud / error when trying to reinstall
« by IceQueen on April 21, 2012, 10:23:48 pm »

...... 'm trying to reinstall cpmFetch but it's giving me this  ............  message:  Quote  Unknown column 'p.owner_name' in 'field list'  SELECT p. ............  pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS  ............  AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS  ............  as aKeyword FROM cpg14x_pictures AS p LEFT JOIN cpg14x_users AS u ON p.owner_id = u.user_id LEFT  ............  cpg14x_albums AS a ON p.aid = a.aid LEFT JOIN cpg14x_categories AS c ON a.category = c.cid  ............  = "")) ORDER BY p.ctime DESC LIMIT 0,4  Warning: mysql_fetch_assoc(): supplied argument is not a  ............  MySQL result resource in /home/matthewm/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1260  Warning: mysql_free_result(): supplied  ............  is not a valid MySQL result resource in /home/matthewm/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1264   ......
12
cpg1.4 miscellaneous / CRITICAL ERROR MESSAGE
« by iminthatpicture on August 13, 2010, 03:49:55 pm »

......  my galleries I got this message "There was an error while processing a database query  my website is  ............ .iminthatpicture.com  the link to the page is http:// ............ .iminthatpicture.com/gallery/thumbnails.php?album=106   ............  see that the error is with all my galleries  the debug messages i  ............  are as followsQuote  While executing query "SELECT pid, filepath, filename,  ............ %' )) ORDER BY pid DESC LIMIT 0 ,20" on 0  mySQL error: Unknown column 'owner_name' in 'field list............  => 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  [ ............  cpg_filetypes; (0s) [1] => select * from cpg_plugins order by priority asc; (0s)  [2] => delete  ............  AS group_id FROM `dredlocs_copp1`.cpg_users AS u INNER JOIN `dredlocs_copp1`.cpg_usergroups AS g ON u. ............  u.user_id='1' (0s)  [7] => SELECT user_group_list FROM `dredlocs_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  ............ , title, aid, keyword, description, alb_password_hint FROM cpg_albums WHERE aid='97' (0.002s)  [15]  ............ ---- Array ( )  ========================== VERSION INFO : ------------------ PHP version: 5.2.13 - OK -- ............ ---------------- mySQL version: 5.0.89-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.89   ............  external  MYSQL_SOCKET /var/lib/mysql/mysql.sock  MYSQL_INCLUDE - ............ /usr/include/mysql  MYSQL_LIBS -L/usr/lib64 -lmysqlclient  ............  compress.zlib://  Stream Filter support zlib.inflate, zlib.deflate  Compiled Version 1.2.3   ............  | no value safe_mode_gid | Off | Off safe_mode_include_dir | no value | no value safe_mode_exec_dir  ............  | 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 | 120 | 120 max_input_time | 120 | 120 upload_max_filesize | 200M |  ............  | 32M ========================== Page generated in 0.063 seconds - 20 queries in 0.019 seconds -  ............  set : ; Meta set: ;    THANKS IN ADVANCE FOR ANY  ......
13
cpg1.5 upgrading / Upgrade Issues
« by allyssaam on March 29, 2011, 01:14:39 am »

......  little new here so forgive me if this was posted in the wrong place or anything. But heres my problem: ............  My Site in case needed (http://gallery.transylvaniaonline. ............ /index.php)  Yesterday, I upgraded, or tried to  ............  my Gallery using Fantastico, I dont even think its updated since  ............  still says I can upgrade it, and ever since I havent been able to upload photos, or even  ............  them in full size, everytime, I get this error:   "There  ............  an error while processing a database query.  While  ............  ((aid='255' ) ) ORDER BY pid DESC " on 0  mySQL error: Unknown column 'owner_name' in 'field list............ "  Debug Error:  USER:  ------------------ Array (  [ID] =>  ............ - Array (  [user_id] => 1  [user_name] => admin  [groups] => Array  (  => 1  ............   )   [disk_max] => 0  [disk_min] => 0  [can_rate_pictures] => 1  [ ............ ] => 1  [ufc_max] => 3  [ufc_min] => 3  [custom_user_upload] => 0  [ ............ ] => 1  [can_create_albums] => 1  [has_admin_access] => 1  [pub_upl_need_approval] => 0   ............ ] => 0  [group_name] => Administrators  [upload_form_config] => 3  [ ............  cpg_filetypes; (0s) [1] => select * from cpg_plugins order by priority asc; (0s)  [2] => delete  ............  AS group_id FROM `transylv_copp1`.cpg_users AS u INNER JOIN `transylv_copp1`.cpg_usergroups AS g ON u. ............  u.user_id='1' (0s)  [7] => SELECT user_group_list FROM `transylv_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  ............ ---- 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 -lmysqlclient  ............  compress.zlib://  Stream Filter support zlib.inflate, zlib.deflate  Compiled Version 1.2.3   ............  | no value safe_mode_gid | Off | Off safe_mode_include_dir | no value | no value safe_mode_exec_dir  ............  | 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 | 630 | 630 max_input_time | 6000 | 6000 upload_max_filesize | 800M | ............  | 800M ========================== Page generated in 0.032 seconds - 19 queries in 0 seconds - Album  ............  : ; Meta set: ;"  One more thing, supposedly there is a backup someone it made,  ............  I just cant seem to find it, again let me know if any info needs to  ............  that wasnt in order to help, and to anyone who can, thank you  ......
14
cpg1.5 upgrading / Fatal Errors after upgrading from 1.4.12 to 1.5.18
« by PF on July 29, 2012, 02:38:33 pm »

...... .com/forum/album/  Hi!  I have been using Coppermine since 2005 and this is only my second  ............ . I managed to successfully do the first one in 2007, but am having severe problems this time  ............  SMF 1.1.3 to 2.0.2.  I forgot to disable plug ins before starting the upgrade but I'm 99% certain  ............  I wasn't using any, if that helps.  I FTP'd all the files to  ............ , made sure not to overwrite the albums, /include/config.inc.php and anycontent.php files.  I  ............  using a custom theme and have also attempted to bring  ............  and template.php, although I must admit that changing the theme.php is beyond my understanding.   I  ............  when I go to the next step and try to visit my index page or version check I receive the following  ............  message:  Quote  Fatal error:   While executing query 'SELECT u.ID_MEMBER AS  ............  AS group_id FROM `klicky`.smf_members AS u LEFT JOIN `klicky`.smf_membergroups AS g ON u.ID_GROUP=g. ............  WHERE u.ID_MEMBER='1'' in bridge/udb_base.inc.php on line 70  mySQL error:  ............  column 'u.realName' in 'field list'   I asked the  ............   The problem looks to be that the script is expecting the data to be in a particular place in the  ............  that it is not at. I see that by running this related query:   mysql> SELECT username  ............  `klicky`.smf_members;  ERROR 1054 (42S22): Unknown column 'username' in 'field  ............ '  The problem, in other words, is that there's no field named " ............ " in that table. Perhaps it's the wrong version of the  ............  script.    I must have completely messed something up somewhere.   I have a backup of the  ............  needed. (I could probably work it out with some instruction.) Attached is a screenshot from  ............  searched the forum and found some topics discussing similar problems to mine. Even after trying to  ............  the suggestions made to others, I keep coming back to those "Fatal Error" pages.  I really  ............  that I have provided you with all the required information and that you can help me.  ......

......  taht tha table cpg132_users does not have the field user_disk_quota , created. Whwt shoul I do?  ............  the table myself? , reupgrade?  While executing query "INSERT INTO cpg132_users (user_regdate,  ............ , user_name, user_password, user_email, user_profile1, user_profile2, user_profile3, user_profile4,  ............ ', 'miky', 'aaaaaaaa', 'info@yahoo.es', 'aa', 'aa', 'aa', 'aa', 'aa', 'aa', ' ............ ')" on 0  mySQL error: Unknown column 'user_disk_quota' in 'field  ......
16
cpg1.5 upgrading / Fatal error
« by DeeDee on January 13, 2011, 06:49:54 pm »

......  tell me what I need to do to fix this?  Fatal error:  While executing query 'SELECT MAX(group_quota)  ............  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 (3)' in bridge/udb_base.inc.php on line 309   ............  error: Unknown column 'upload_form_config' in 'field  ............ .net/gallery/. The update script ran fine. Thanks!  ......
17
cpg1.5 miscellaneous / Problmes with installation of CMPfetch
« by natia_a7x on January 06, 2011, 09:49:28 pm »

...... 've updated coppermine gallery on my site http://kimcloutier.fan-sites. ............  and after that my cpmfetch stopped showing latest images on my main page, so i deleted it  ............  tried to reinstall but i got error like this   Quote  Warning:  ............ (): supplied argument is not a valid MySQL result resource in /home2/kimclout/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1260  Warning: mysql_free_result(): supplied  ............  is not a valid MySQL result resource in /home2/kimclout/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1264    And instead of images it showed this   ............   Unknown column 'p.owner_name' in 'field list'  SELECT p. ............  pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS  ............  AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS  ............  as aKeyword FROM cpg14x_pictures AS p LEFT JOIN cpg14x_users AS u ON p.owner_id = u.user_id LEFT  ............  cpg14x_albums AS a ON p.aid = a.aid LEFT JOIN cpg14x_categories AS c ON a.category = c.cid  ............  BY p.ctime DESC LIMIT 0,4    PLZ help... thanks in  ......
18
cpg1.5.x Français (French) / Fatal error suite mise à jour
« by vero83 on September 10, 2012, 01:15:04 pm »

......  que je suis bannie du site et un message fatal error sur toutes les autres pages du site.  Voici le  ............  activant le mode debug dans la BDD:  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'   ......

......  had recently installed Coppermine 1.5 but switched back to 1.4  ............  after. Everything was working fine but when I created a album and  ............  to look at it/upload anything to it, I got "Critical error There was an error  ............  processing a database query".  I ran debug mode and this  ............  what I got as a message -   There was an error while processing a database query.  While  ............ , pheight, ctime, aid, keywords, votes, pic_rating, title, caption,hits,owner_id,owner_name from  ............ ='250' ) ) ORDER BY filename ASC LIMIT 0 ,36" on 0 mySQL error: Unknown column 'owner_name' in 'field list............  => 1   )   [disk_max] => 0  [disk_min] => 0  [can_rate_pictures] => 1  [ ............ ] => 1  [ufc_max] => 3  [ufc_min] => 3  [custom_user_upload] => 0  [ ............ ] => 1  [can_create_albums] => 1  [has_admin_access] => 1  [pub_upl_need_approval] => 0   ............ ] => 0  [group_name] => Administrators  [upload_form_config] => 3  [ ............ ; (0s) [1] => select * from cpg14x_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  ............  group_id FROM `rebeccab_becky`.cpg14x_users AS u INNER JOIN `rebeccab_becky`.cpg14x_usergroups AS g  ............  u.user_id='1' (0s)  [7] => SELECT user_group_list FROM `rebeccab_becky`.cpg14x_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 cpg14x_usergroups WHERE group_id in (1) (0s)  [9] => SELECT group_name FROM  ............ , title, aid, keyword, description, alb_password_hint FROM cpg14x_albums WHERE aid='250' (0s)  [19]  ............ , pheight, ctime, aid, keywords, votes, pic_rating, title, caption,hits,owner_id,owner_name from  ............ ---- Array ( )  ========================== VERSION INFO : ------------------ PHP version: 5.2.15 - OK -- ............ ---------------- mySQL version: 5.0.92-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.92   ............  external  MYSQL_SOCKET /var/lib/mysql/mysql.sock  MYSQL_INCLUDE - ............ /usr/include/mysql  MYSQL_LIBS -L/usr/lib -lmysqlclient   ............  compress.zlib://  Stream Filter support zlib.inflate, zlib.deflate  Compiled Version 1.2.3   ............  | no value safe_mode_gid | Off | Off safe_mode_include_dir | no value | no value safe_mode_exec_dir  ............ ,passthru,readfile,shell_exec,proc_close,proc_open,ini_alter,dl,popen,parse_ini_file,show_source, ............ ,passthru,readfile,shell_exec,proc_close,proc_open,ini_alter,dl,popen,parse_ini_file,show_source, ............  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 | 60 | 60 max_input_time | 60 | 60 upload_max_filesize | 6M | 6M  ............  8M | 8M ========================== Page generated in 0.066 seconds - 27 queries in 0.001 seconds -  ......
20
cpg1.5 upgrading / Fata Error While Updating
« by severeidaho on November 09, 2010, 07:09:06 am »

......  http://www.severeidaho.com/gallery/   Error    While executing query 'SELECT MAX( ............ ) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures)  ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS  ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval,  ............  FROM cpg143_usergroups WHERE group_id in (1)' in bridge/udb_base.inc.php on line 321   ............  error: Unknown column 'access_level' in 'field list'     ............  have enabled Debug_mode thru myphpadmin...   I cant seem to figure out how to fix the  ............  other similar Posts but None matched to my exact list of errors.   I appreciate any help.     ......

...... 've upgraded to 1.5 but keep getting the following error, did have 1.5 displaying,  ............  were showing, but when went to click on thumbnail I got an  ............  and when went to log in. Have followed upgrade instructions , adding and  ............  code etc.   While executing query 'SELECT MAX(group_quota) as disk_max, MIN............ ) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX( ............ , 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 (3)' in bridge/udb_base.inc.php on line 309   ............  error: Unknown column 'upload_form_config' in 'field  ......
22
cpg1.5 upgrading / Fatal error after upgrading 1.4 to 1.5
« by Alans on March 07, 2012, 12:53:04 pm »

......  help me out with my gallery.  My gallery worked fine under 1.4. After my PHP was updated the gallery  ............  some errors:  Deprecated: Assigning the return value of new  ............  reference is deprecated in /usr/home/siamweb/public_html/fotoboek/include/ ............ .inc.php on line 134  So I decided to update my  ............  gallery in the hope to get rit of that error.  I downloaded  ............  latest 1.5 coppermine version and overwrite all the files except the  ............ .php .  I run the update.php and that looked fine, no errors.  When i try to reach my gallery I  ............  a Fatal Error.  I activated the debug mode and I got the same  ............ :  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'   ............  the new 1.5 gallery files. I put my old config.inc.php in the include map. then i run the update. ............  get all results "already done"  When I go to my index.php from I get this error:   While executing  ............  '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 (3)' in bridge/udb_base.inc.php on line 323   ............  error: Unknown column 'access_level' in 'field list'    ............  i look at my MySql tables i see that the filenames from the tables  ............  still beginning with 1.4 and not 1.5  I hope somebody can  ......

......  am using Phpnuke (Nuke evolution). I want to use  ............  decide to move 8.000 pix and 850 users. I did as instructed, run the update.php successfully and get  ............  error at the homepage.  I searched the forum but i can' ............  find the solution  There was an error while  ............  a database query. While executing query "SELECT aid FROM cpg_albums WHERE  ............ != '0' AND visibility !='10000' AND visibility NOT IN (3)" on 0  mySQL error: Unknown column 'aid' in............  list'  USER:  ------------------ Array (  [ID] =>  ............ ] => 0  [disk_max] => 0  [disk_min] => 0  [ufc_max] => 3  [ufc_min] => 3  [ ............  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  ............ != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s) )  ========================== GET : ----- ............  ( )  ========================== Page generated in 0.032 seconds - 12 queries in 0 seconds - Album  ......
24
cpg1.5 upgrading / Re: Fatal Error after upload.
« by Αndré on March 17, 2011, 09:13:35 am »

......  search the board for that error message: Quote  mySQL error: Unknown column............ ' in 'field list'   You'll find a lot of solved topics. ......

......   mySQL error: Unknown column 'group_id' in 'field list'   ............  Welche Spalten gibt es denn in der Tabelle phpbb_sessions? ......
26
cpg1.5 miscellaneous / Error after upgrade to 1.56 stable
« by MONARCH on June 13, 2010, 05:53:17 pm »

......  have read the docs about posting and searched the board for answers.  I upgraded  ............  1.56 and the gallery works fine.   However, i cannot use cpmfetch.  The gallery  ............  at: http://www.monarchhousing.org/gallerynew/  In searching the board I found  ............  about possible problems with plugins and mods. i have no plugins or mods.  I have  ............  myphpadmin to check the database and found no problems.   ............  is the error message:  Test images - found a total of 1722  ............  from your gallery displayed here. If not, you may in fact have a problem and will need to seek help by  ............  here.  Unknown column 'p.owner_name' in 'field list' SELECT p. ............  pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS  ............  AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS  ............ .keyword as aKeyword FROM cpg_pictures AS p LEFT JOIN cpg_users AS u ON p.owner_id = u.user_id LEFT  ............  cpg_albums AS a ON p.aid = a.aid LEFT JOIN cpg_categories AS c ON a.category = c.cid WHERE 1  ............  = "")) ORDER BY p.ctime DESC LIMIT 0,4   Warning: mysql_fetch_assoc(): supplied argument is not a  ............  MySQL result resource in /home6/monarchh/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1260  Warning: mysql_free_result(): supplied  ............  is not a valid MySQL result resource in /home6/monarchh/public_html/ ............ /cpmfetch/cpmfetch_dao.php on line 1264  I will appreciate any help that you can  ......
27
cpg1.5 upgrading / Re: Updating from 1.4.25 (stable) bridged to SMF
« by Nightmaster on January 26, 2014, 10:02:49 pm »

......  for double-posting, but i couldn't see an option for edit previous  ............  though.  Here's what i'm getting when i turn on debug mode:  Quote  While  ............  `pavel_forum`.parnat_forum_members AS u LEFT JOIN `pavel_forum`.parnat_forum_membergroups AS g ON u. ............ =g.ID_GROUP WHERE u.ID_MEMBER='23699'' in bridge/udb_base.inc.php on line 70  mySQL error:  ............  column 'u.realName' in 'field list'    ......
28
cpg1.4 miscellaneous / Unknown Column error :(
« by ishi92 on August 23, 2010, 06:17:37 pm »

......  just tried updating my Coppermine Gallery from version 1.4.19 to 1.5. ............ , but I got the error :  Upgrade failed! Errors are:   Upgrade failed ( ............ 't coerce GLOB to string in or at /opt/lib/perl5/bl/BL/InstallCentral/ ............ .pm line 160.  Stack:  [/opt/lib/perl5/bl/BL/ ............ /Coppermine.pm:160]  [/opt/lib/perl5/bl/BL/InstallCentral/ ............ .pm:124]  [/opt/lib/perl5/bl/BL/InstallCentral/Installer.pm:655]  [/opt/lib/perl5/ ............ /BL/InstallCentral/Installer.pm:620]  [/home/bizland/ ............ /InstallCentral/Applications/autohandler:1483]  [/ ............ /Mason/Request.pm:908]  [/home/bizland/member/InstallCentral/Applications/autohandler:2112]  [/ ............ /bizland/member/InstallCentral/Applications/autohandler:1463]  [/ ............ /Mason/Request.pm:908]  [/home/bizland/member/InstallCentral/Applications/autohandler:2105]  [/ ............ /bizland/member/InstallCentral/Applications/autohandler:28]  [/opt/ ............ /Mason/Request.pm:908]  [/home/bizland/member/InstallCentral/Applications/autohandler:2171]  [/ ............ :9] )!   So I enable the debug mode from phpMyAdmin and I reloaded my gallery. I now get the error :   ............  While executing query 'SELECT MAX(group_quota) AS disk_max, MIN............ ) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX( ............ ) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS  ............ , MIN(pub_upl_need_approval) AS pub_upl_need_approval,  ............  FROM cpg148_usergroups WHERE group_id in (3)' in bridge/udb_base.inc.php on line 321   ............  error: Unknown column 'access_level' in 'field list'  I  ............  gallery. Please help! My gallery : www.tokiohotelindia.com/gallery   ......
29
cpg1.5 upgrading / Fatal error when upgrading from cpg1.4.25 to cpg1.5.8
« by JohnH on October 31, 2010, 03:58:49 pm »

...... ://www.billyelliottheforum.me.uk/gallery/  Upgrading from 1.4.25 to 1.5.8 with no plug-ins. Using  ............  tried to run update.php and got the generic Fatal error page. Searching the forums I discovered that I  ............  have disabled bridging before upgrading so I restored all of the 1.4.25  ............ , logged in and disabled the bridge. I also followed the  ............  of deleting all the files in the gallery except for the  ............  folder and include/config.inc.php.  I uploaded all the 1.5.8  ............  few seconds with no output and then displayed the index page using the curve theme but it didn't ask  ............ /password. As soon as I clicked on any of the links in the menu I got the generic Fatal error page.  ............  Using the instructions at http://documentation. ............ -gallery.net/en/errors.htm#errors_fatal I used phpMyAdmin to enable  ............ . The debug output gave me the error: mySQL error: Unknown column 'access_level' in............  list'.  I started working through the suggestions in  ............  post: http://forum.coppermine-gallery.net/index.php/topic,65521.0.html and  ............  the advice offered by Joachim in this post I started running all the queries in  ............ /update.sql using phpMyAdmin. I got errors on some of the queries  ............  and it didn't occur to me to keep a record of the error messages) but my years of fiddling with various  ............  of SQL allowed me to rectify all the errors except one.  When I run the query Code: [Select]  ............  TABLE cpg_filetypes DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` );  ............  get the error message Code: [Select] #1091 - Can't DROP ' ............ '; check that column/key exists I have checked the structure of  ............  and the field 'extension' exists.  I don't know if it helps or  ............  but I also ran Code: [Select] SHOW INDEX FROM `cpg_filetypes' and got the following  ............ : [Select] Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality  ............  Packed Null Index_type Comment cpg_filetypes 0 PRIMARY  ............  NULL BTREE  Can I get away without running this query or can some tell me what is wrong  ............  it/my database?  The gallery seems to be working now in that I am no-longer getting the fatal  ............  message and I am able to log in. However versioncheck.php is reporting a lot of  ............  files (501) as having been modified so I'm going to re-upload all of  ............  files showing an error with a fresh download of 1.5.8. ......
30
cpg1.5 upgrading / update to 1.5.10 , no upload, no detailview
« by Maddin on December 29, 2010, 07:29:15 am »

...... , the search has not displayed properly in the forum my mistake.  I have updated to version  ............ .5.10. I think that was before the 1.4.11 version modded by  ............ . CPG is actually quite good, but I have the following problems.   Only the admin user can see images  ............  the detail view. Only the admin user can upload pictures. I put a new user, it  ............  these pictures, but he can not see any pictures in the detail view. Existing users can not upload  ............  user wants to upload pictures, he gets this error:  You have no right to view this page.   File: /  ............  If another user or a guest wants to see a picture in the details, he gets this error:   While  ............  query "INSERT INTO cpg1411_hit_stats SET pid = 1454  ............ . php? album = 8 ', browser =' IE8 ', os =' Windows 7 ', uid = '0''in include / functions.inc.php  ............  line 2765   mySQL error: Unknown column 'uid' in............  list'   ----------   Why is the error message  ............  does not work completely? I have checked again via the Admin Interface tables. Do I delete the  ............ ? Also with the standard template I get this error.   Registered users have rights to view all  ............  created user is from the same group as an existing.   Can someone help me?   Thank you  ......
Pages: [1] 2 3 4 5 ... 7

 

Page created in 0.365 seconds with 30 queries.