Can someone check thier custom pages...

[thetrusteeco]

Hello all.

I'm not looking to blame KBKP, or call the a bug/breakage, unless someone has the same issue. It could be a local problem.

I just did an update, and it seems to have fubarred by site.  Do any of you have custom pages calling custom text values?  If so, can you check if those page are displaying the right text.

For me this is beyond confusing (looks like the website is pulling data from the database 3-6 months ago!):
Issue 1: the pages are showing the wrong text.  The page .tpl files themselves have not changed.  I can see the right queries in the .tpl file, and when I look at the text in the Admin area it is right, but the pages are showing the wrong text.
EG: my page for .ac domains is showing the text for .io domains.  I have a different custom page for each TLD.  What is truly confusing is that it is right in the .tpl, and right in the Admin text-area.

This by itself is odd but wait, there's more:
Issue 2: some pages are showing a 3-6 month old version or the text.
IE: I changed these pages 3-6 months ago, by replacing the text, and now the old text is showing on the external site, but the admin area is showing the current version.  And no, just re-saving the current version doesn't work. 

To further confuse the issue, I pulled open the SQL and the new text values are in there, not the old text.  Where would HostBill pull old text from?  And why would the admin and external site be showing different data?

Any random guesses would be welcome.  The way this is going I'm going end up with Einstein-hair!

[thetrusteeco]

Could anyone running HostBill on MariaDB confirm if your config.php file lists your DB as "mysql" or "mariadb"

$db_engine = 'mysql';

Right at the bottom of Config.

I'm just looking at everything now.  I doubt this is truly relevant.

[thetrusteeco]

I think I found the error causing #1.  I have to rewrite a few thousand variables in the database, I'll be back in a couple hours.

[thetrusteeco]

I found the cause of the second error as well. 

Not sure what caused it, but both errors are in the SQL, however I have no explanation for why the admin area was showing different data than the website itself.  Perhaps browser caching.

I will assume that this is not a hostbill issue unless someone else has the same issue.

[thetrusteeco]

Okay, problem solved, not sure cause.

A second "English" Client Language appeared, and apparently copied older data out of a language file that was disabled a few months back.  If this happens to anyone else, once we deleted the second English file, everything reverted to the original English file, and the text was as it should be.

Not sure what created the duplicate English file, could be a localized phenomena.

[Patrick]

That's incredibly odd.  This was after an update?

[thetrusteeco]

Yeah, it was right after the most recent update.  I did the auto-update, and went to check everything was okay, and then had a WTF moment.

Ultimately though I don't know what caused it, and am not blaming KBKP, we recently (72 hours ago) upgraded our servers from MySQL to MariaDB and that might have had something to do with it, although I haven't found any other issues yet.  It was fine in between the MariaDB upgrade and the HostBill update...

I originally posted this because I was seeing different text being displayed on the website than in the admin area.  And that made me want to pull out my hair!  I hate positing an "I'm an idiot and broke my website" thread, but figured if it is KBKP orientated someone else might have run into it.

Admin was pulling data from the original English file, while the website was pulling from the new English file, which apparently included text copied from one of the non-active languages we were working on translating around new-years.  If anyone else encounter this, please check you don't have 3 (Your-Language) files in HostBill SQL, there should be 2 in the SQL, Admin and Client.  In the HostBill admin area there should be 1 under client and 1 under admin.