Single Quote in Exhibition title (VERIFIED)

[HMetal]

I just upgraded to 2.02 and I've found that any title with a single quote (') in it, will display a backslash before it.

I've checked with phpMyAdmin and the the title is "Ray's Photography Portfolios" but EE is adding a backslash when it displays the name, so it appears as "Ray\'s Photography Portfolios"

[yosemite]

hi ray,

i tried it on my 2.2 and it displays right, must be a local php problem?

[Pekka]

The \'s problem seems to be result of pre 2.02 bug (double slashes) in some fields (guestbook text (ee_exhibition_feedback table) has that problem among others). I'll need to write a script that goes though all text fields and fixes those. If you are in a hurry, one way to fix those is simply to backup the database (or just language tables like ee_exhibition_eng) with EE Backup and restore it - EE Backup fixes orphan slashes automatically.

[HMetal]

The \'s problem seems to be result of pre 2.02 bug (double slashes) in some fields (guestbook text (ee_exhibition_feedback table) has that problem among others). I'll need to write a script that goes though all text fields and fixes those. If you are in a hurry, one way to fix those is simply to backup the database (or just language tables like ee_exhibition_eng) with EE Backup and restore it - EE Backup fixes orphan slashes automatically.

Well, that might have worked but for some reason, after using EE backup and then restoring the backup, my EE index no longer works. All I see is a blank screen.

I used EE admin and I can see all my photos, exhibitions and groups but in paths, there is no longer anything listed in the "Thumb Path Editor"

How to fix Pekka? I am stuck with a non-working EE. Only admin functions work. Why did ee backup mess up my database?

HELP!!

Update: I re-added the thumb path that was missing with the proper thumbpath. Problem now is EE thumb path editor shows that both thumbs and microthumbs are *not* used in any exhibitions.

[Pekka]

Did you select all tables when doing backup?

EE Backup does not restore corrupt data, it gives error messages if it sees one. So I have no clue why the restore failed. Only scheme I can image would do this is that you make a partial backup, delete all tables with phpmyadmin and then restore partial backup.

Maybe you could PM me info how to login to your EE and I can take a look.

When you create a new thumb path it gets a new id, too. So to use it you need to go to exhibition editor and assign the path.

Blank screen is usually an indiciation of wrong style path(s) or missing style files. Other option is PHP error (missing include files).

[HMetal]

Pekka, it all blew up using ee backup. all tables alphabetically above ee_style now contain no data. :(

I don't know what went wrong but, I'm going to see if I can restore a pre-2.0 backup and do the upgrade again. Good thing I havnen't added many photos since the upgrade.

If this works and I can somehow get to where I was before using ee backup, I'll use phpmyadmin and make sure all tables are "repaired," then I'll upgrade and try the ee backup thing again. I should have made a backup with phpmyadmin first.

Ah well, you live, you learn ... backup backup backup! :(

[Pekka]

Pekka, it all blew up using ee backup. all tables alphabetically above ee_style now contain no data. :(

First time I've seen that. I'll try to see if there is any possibility of a bug there, but I suspect more a server hiccup during backup.

Did those missing table have DROP and CREATE statements in backup file, or were only INSERT statements missing?

I don't know what went wrong but, I'm going to see if I can restore a pre-2.0 backup and do the upgrade again. Good thing I havnen't added many photos since the upgrade.

If this works and I can somehow get to where I was before using ee backup, I'll use phpmyadmin and make sure all tables are "repaired," then I'll upgrade and try the ee backup thing again. I should have made a backup with phpmyadmin first.

Ah well, you live, you learn ... backup backup backup! :(

Yes, backing up is something worth doing, I do it every day many times :) Happy to hear you have a way to recreate the gallery!

I would love to solve what happened but it would need a way to reproduce it - if you can, do a file backup of the new system and do not restore it, just view the file and see if it's all there.

[HMetal]

First time I've seen that. I'll try to see if there is any possibility of a bug there, but I suspect more a server hiccup during backup.

Did those missing table have DROP and CREATE statements in backup file, or were only INSERT statements missing?



It is actually worse than that. The tables were created BUT the backup contained no data/records in those tables. I know that data was there but ee_backup did not create any backup statements for that data.

[Pekka]

It is actually worse than that. The tables were created BUT the backup contained no data/records in those tables. I know that data was there but ee_backup did not create any backup statements for that data.

Could you do a similar backup and view its contents ("Display" or "Show dump", depending on backup type)? Does it now have INSERT statements for those tables?

Do NOT restore it, obviously.