udate from 11d and no pics

[searanch]

Everything went smoothly. Install, update, etc. edited confi.inc.php to show cpg11d and still can't get my pics.

Appreciate any help...

...and yes I read first

[Joachim Müller]

I don't understand a word. Use more words to explain your actual issue (an error message or what?), and post a link to your site.

Joachim

[searanch]

...no error messages during install, update

I edited config.inc.php to show cpg11d

still no pics

The gallery are working and a bridge has been built to the SMF forum and login logout performs correctly. Just no pics after the update which appeared to perform correctly.

[Joachim Müller]

where's the link?

Joachim

[searanch]

.

[Tranz]

You had a previous installation that had photos?

[searanch]

I had a full gallery - hence the update.

[Tranz]

Was the previous gallery version in the smf directory?

[searanch]

Yes it was renamed from YaBBSE

[Joachim Müller]

Do you have phpMyAdmin or a similar tool that let's you access the database directly?

Joachim

[searanch]

yes

[Joachim Müller]

PM me this data:

• The URL of this thread
  
• The URL of your gallery
  
• Your coppermine admin username and password
  
• Your ftp access data (hostname, username, password)
  
• Your phpMyAdmin data (URL, username, password)

Joachim

[Joachim Müller]

you appear to have two coppermine installs (at least that's what your database is suggesting, as you have one install with the mySQL table prefix cp11d_ and cpg132_). Both of them contain no data (no pics, albums, users, categegories). You appear to have messed with the database manually. Use your database dump you created before upgrading and restore your db (the coppermine tables, to be more exact - do not touch your yabbse tables) to how it used to be before the upgrade.
The ftp data you sent me are not sufficient to connect, so I can't check wether the pics are actually there.

Joachim

[searanch]

This was a coppermine install and integration with YaBBSE and three yabbse files were created. They contain the data.

I dropped the files

cpg11d_albums
cpg11d_comments
cpg11d_pictures

and renamed the three yabbse files to replace them and ran update.php. I must be making some progress as at least now I am getting errors. It would appear that certain fields are missing in albums, comments and pictures.

Hopefully this will assist you in fixing my problem. Thanx for your help - most appreciated...

[Joachim Müller]

your posting is irrelevant: YaBB SE files are not involved. In fact, no files are involved at all, but database entries are. If you want my help, do as I suggested.

Joachim

[searanch]

your posting is irrelevant: YaBB SE files are not involved. In fact, no files are involved at all, but database entries are. If you want my help, do as I suggested.

In the process of doing exactly as you suggested was when I made the discovery that the orginal cpg11d_tables albums, comments and pictures did not have database entries. After scratching my head I then noticed the first three tables yabbse_gallery_tables listed below and made the discovery that this was where the database entries were.

I understand that YaBB SE files were not involved. When coppermine was first installed it was integrated with YaBB SE it created the following three tables:

yabbse_gallery_albums
yabbse_gallery_comments
yabbse_gallery_pictures

These three tables contained the database entries. I deleted the following three tables this morning which never contained any database entries before/after the update.php process.

cpg11d_albums
cpg11d_comments
cpg11d_pictures

And replaced the three tables with the first three tables and ran update.php again. It obviously didn't add all the fields necessary and I now get error codes in the current install of Coppermine. I consider this some progress.

You can now see the relevant data entries in the new tables album, comments and pictures. Fields are missing.

I very much appreciate your help and am trying to make this as easy as possible for you to solve. Thank you in advance of your further assistance is this matter...

[searanch]

Joachim,

I have reconciled the field differences between the cpg132_ tables and the new cpg11d_ tables I created from the above referenced tables. I can now recognize the 1224 pics and 49 albums in the new Install of Coppermine, but cannot view them.

I believe it is because I do not know how to reconcile the differences between the Indexes: of the cpg132_ and cpg11d tables. I am getting closer and making every effort to help myself and learn at the same time.

cpg11d_albums
cpg11d_comments
cpg11d_pictures

I would appreciate your help in getting over this last hurdle. Thank you in advance of your assistance in this matter...

[searanch]

Solved...

[Tranz]

Thank you for letting us know that it was solved, searanch. Could you possibly share how it was solved for the benefit of other users?

Thanks.

[searanch]

Thank you for letting us know that it was solved, searanch. Could you possibly share how it was solved for the benefit of other users?

We had Coppermine 11d indegrated into our YaBBSE 1.5. We upgraded to SMF once the final release was done. What we didn't realize was the fact that the integration of Coppermine in YaBBSE was not bridged but produced 3 tables yabbse_gallery_ labeled albums, comments and pictures which, it turned out contained the data references. Of course the update didn't know that and converted the cpg11d_ tables and voila no data.

I discovered when I dumped the original cpg11d_ tables to the database and reran another update I got the same result - no data references. After discovering the yabbse_gallery_tables I renamed them cpg11d_albums, comments and pictures. I then rebuilt the tables to mirror the missing fields and indexes. I could then get the pics, comments in admin only. Discovered that all the pic files had the approval field set at NO and then changed globally the value to YES.

We're in business. Thanx to Casper, Nibbler and Tranz for all your help.