Fatal Error On Upgrade..

[Toblet]

Hi guys,

I upgraded to the latest version of CPG and got this error,

Fatal Error

While executing query 'SELECT name, value FROM cpg15x_config' in include/init.inc.php on line 181

mySQL error: Table 'tbrack_nsjedi33.cpg15x_config' doesn't exist

Can someone please tell me how to fix this,

Thank you,

Toby =)

[Toblet]

I didn't the right config in the config file,

Now I get this:

Fatal error: require_once() [function.require]: Failed opening required 'bridge/e107.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tbrack/public_html/e107_plugins/cpg15x/include/init.inc.php on line 243

Any idea on how to fix it,

Thanks,

Toby =)

[Toblet]

Got the next part fixed, now I get:

"Please, enter relative path to e107"

Then a text box below and file path in it,

Does coppermine think im not installing it in e107 because I am..

[Toblet]

Hi guys,

I get this fatal error after I upgraded:

Fatal Error:

While executing query 'SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MIN(can_rate_pictures) as can_rate_pictures, MIN(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MIN(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MIN(can_post_comments) as can_post_comments, MIN(can_upload_pictures) as can_upload_pictures, MIN(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MAX(pub_upl_need_approval) as pub_upl_need_approval, MAX( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg1410_usergroups WHERE group_id in (103)' in bridge/e107.inc.php on line 471

mySQL error: Unknown column 'upload_form_config' in 'field list'

Does this have todo with the bridge, after I posted it here I could see at the end it says line 471 in my bridge file??

[Toblet]

If I disable the bridge in mysql I get this:

While executing query "SELECT aid FROM cpg1410_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3)" on 0

mySQL error: Table 'tbrack_nsjedi33.cpg1410_albums' doesn't exist

USER:
------------------
Array
(
    [ID] => 863160ae149a0a6594ad5dd95128c896
    [am] => 1
    [lang] => english_gb
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
           

• => 3
          )
  
      [group_quota] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 0
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 0
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 1
      [upload_form_config] => 3
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [custom_user_upload] => 0
      [can_see_all_albums] => 0
      [disk_max] => 0
      [disk_min] => 0
      [ufc_max] => 3
      [ufc_min] => 3
      [has_admin_access] => 0
      [group_name] => Guests
      [group_id] => 3
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg1410_filetypes; (0.071s)
      [1] => select * from cpg1410_plugins order by priority asc; (0.001s)
      [2] => SELECT * FROM cpg1410_bridge (0.004s)
      [3] => SELECT * FROM `tbrack_nsjedi33`.e107_userclass_classes WHERE `userclass_name` = 'COPPERMINE_ADMIN' (0.113s)
      [4] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MIN(can_rate_pictures) as can_rate_pictures, MIN(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MIN(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MIN(can_post_comments) as can_post_comments, MIN(can_upload_pictures) as can_upload_pictures, MIN(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MAX(pub_upl_need_approval) as pub_upl_need_approval, MAX( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg1410_usergroups WHERE group_id in (3) (0.03s)
      [5] => SELECT group_name FROM  cpg1410_usergroups WHERE group_id= 3 (0s)
      [6] => DELETE FROM cpg1410_banned WHERE expiry < '2011-08-21 19:00:11' (0.094s)
      [7] => SELECT * FROM cpg1410_banned WHERE (ip_addr='60.240.203.113' OR ip_addr='60.240.203.113' OR user_id=0) AND brute_force=0 (0.003s)
      [8] => SELECT aid FROM cpg1410_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  Page generated in 2.231 seconds - 9 queries in 0.316 seconds - Album set : ; Meta set: ;

[Αndré]

Please post a link to your gallery. I merged your two threads as you haven't resolved one of them. What's the current issue? Please explain exactly what happens.

[Toblet]

Okay, cheers,

Gallery is: http://nsjedi.com/e107_plugins/gallery/

Please give me any advice so I can fix it,

Thank you,

Toby =)

[Αndré]

While executing query "SELECT aid FROM cpg1410_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3)" on 0

mySQL error: Table 'tbrack_nsjedi33.cpg1410_albums' doesn't exist

Please check if that table exists in your database. Verify that the database name and the table prefix are the correct ones. If it doesn't exist, restore it from a backup and run update.php again.

[Toblet]

Hi Andre,

I looked in config.inc.php, I hope thats the file for connections to database, all was correct,

I tried to get backup from my hard drive, non had the albums table - also tried from hosting company, no go,

Not sure why it happened, I moved the site to a new host bout 6 months ago, I didn't fix the problem then, and then I tried upgrading without fixing the problem, I thought that upgrading would be a fix for it, so not sure how fixable this prob is...

[Αndré]

If you don't have a backup of that table you can create it with the following query. But all of your albums are lost and it might be a time-consuming task to re-create your gallery structure.

Code Select Expand

CREATE TABLE cpg1410_albums (
  aid int(11) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  description text NOT NULL,
  visibility int(11) NOT NULL default '0',
  uploads enum('YES','NO') NOT NULL default 'NO',
  comments enum('YES','NO') NOT NULL default 'YES',
  votes enum('YES','NO') NOT NULL default 'YES',
  pos int(11) NOT NULL default '0',
  category int(11) NOT NULL default '0',
  owner int(11) NOT NULL DEFAULT '1',
  thumb int(11) NOT NULL default '0',
  keyword VARCHAR( 50 ),
  alb_password VARCHAR( 32 ),
  alb_password_hint TEXT,
  moderator_group INT NOT NULL default 0,
  alb_hits INT( 10 ) NOT NULL default 0,
  PRIMARY KEY  (aid),
  KEY alb_category (category),
  KEY `moderator_group` (`moderator_group`),
  KEY `visibility` (`visibility`)
) COMMENT='Used to store albums';

[Toblet]

Yeah, I thought thats what I would have todo, I will have to reconstruct everything piece by piece right?,

I added that table but now for some odd reason it seems to be redirecting to my old subdomain, I had alook but can't find where its coming from, in database or a file

[Toblet]

I found in the bridge in the database it had the old url, I changed it to the current one but now it redirects to the home page

[Αndré]

I will have to reconstruct everything piece by piece right?,

If you lost your complete database (= no tables exist at all) you don't need to restore anything manually, but should install Coppermine from scratch.

[Toblet]

Hey Andre,

All the tables are there except the album one, not sure how that happened, I just get an error now, I think I will just install a new copy and then reconstruct, is there a guide for reconstructing a gallery from scratch...

[Joe Carver]

Ask your hosting company if they have a backup. A copy even a few months old is better than none (IMHO).

[Toblet]

Hey Joe,

I asked them already and they said their backups are only one week old and they don't keep multiples, they save the new over the old, so 1 week is as far back as I can go

[Joe Carver]

If that copy is also damaged, then you should follow Αndré's advice.

is there a guide for reconstructing a gallery from scratch...

The document package that is within the Download can guide you. Or click the Documentation link above. The instructions are detailed.

[Toblet]

Hey Joe,

I didn't loose my complete database though, I just lost the albums table for some strange reason, can you help with this please?,

Toby =)

[Αndré]

1. Install a fresh copy of cpg1.5.16 to a new directory
2. If it works, adjust the config.inc.php file to use your already existing database
3. Now you should see your old gallery (at least the categories), but of course no albums

Confirm if that works and we can proceed to the next steps.

[Toblet]

I installed 1.5.16 and changed the config details, now I get a bridge error

http://nsjedi.com/e107_plugins/cpg15x/index.php