Advanced search  

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]

Pages: [1] 2   Go Down

Author Topic: Fatal Error On Upgrade..  (Read 17108 times)

0 Members and 1 Guest are viewing this topic.

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Fatal Error On Upgrade..
« on: August 20, 2011, 08:40:32 pm »

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 =)
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #1 on: August 20, 2011, 08:51:52 pm »

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 =)
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #2 on: August 20, 2011, 08:57:16 pm »

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..
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Upgrade Fatal Error..
« Reply #3 on: August 21, 2011, 11:07:22 am »

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??
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Upgrade Fatal Error..
« Reply #4 on: August 21, 2011, 05:01:56 pm »

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: ;
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error On Upgrade..
« Reply #5 on: August 22, 2011, 04:32:22 pm »

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.
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #6 on: September 14, 2011, 04:07:54 pm »

Okay, cheers,

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

Please give me any advice so I can fix it,

Thank you,

Toby =)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error On Upgrade..
« Reply #7 on: September 14, 2011, 04:17:24 pm »

Quote
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.
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #8 on: September 14, 2011, 06:32:01 pm »

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...
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error On Upgrade..
« Reply #9 on: September 14, 2011, 06:39:48 pm »

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]
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';
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #10 on: September 14, 2011, 06:55:34 pm »

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
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #11 on: September 14, 2011, 06:59:57 pm »

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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error On Upgrade..
« Reply #12 on: September 14, 2011, 07:00:28 pm »

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.
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #13 on: September 14, 2011, 07:03:59 pm »

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...
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1504
  • aka 'i-imagine'
    • Home Page
Re: Fatal Error On Upgrade..
« Reply #14 on: September 15, 2011, 12:06:12 am »

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

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #15 on: September 15, 2011, 12:38:14 am »

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
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1504
  • aka 'i-imagine'
    • Home Page
Re: Fatal Error On Upgrade..
« Reply #16 on: September 15, 2011, 01:29:09 am »

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

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #17 on: September 15, 2011, 11:19:59 am »

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 =)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Fatal Error On Upgrade..
« Reply #18 on: September 15, 2011, 11:36:51 am »

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.
Logged

Toblet

  • Coppermine novice
  • *
  • Country: au
  • Offline Offline
  • Gender: Male
  • Posts: 30
Re: Fatal Error On Upgrade..
« Reply #19 on: September 15, 2011, 01:33:37 pm »

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

http://nsjedi.com/e107_plugins/cpg15x/index.php
Logged
Pages: [1] 2   Go Up
 

Page created in 0.024 seconds with 19 queries.