blog documentation FAQ followers forum marketplace services youtube

in progress Cannot access site after attempting to downgrade

The Jamroom Network » Forum » Using Jamroom » Page » Cannot access site after attempting to downgrade
iamtimbo
@iamtimbo
10 years ago
301 posts
Hi, all,

In a nutshell:

I downloaded new Site Builder, and then one by one disabled old SB modules before activating new SB.

Quickly realised that I was going to need to go back to old SB (I think I need to export the old setup to bring into the new one). I activated the maintenance mode, disabled new SB, and began re activating old SB modules.

I think I had done the first one, and on saving changes to the second one, I was faced with the header, the menu, and a blank white screen. The 'admin' link by the ACP menu had disappeared, so I manually logged out to try logging in again - and I can't - it's just the header, the menu and a blank white screen...

Help!

EDIT: My laptop is still logged in as Admin, but the white screen issue is persistent. I cannot access the ACP - or any page....
updated by @iamtimbo: 12/22/16 11:55:59AM
brian
@brian
10 years ago
10,148 posts
iamtimbo:
Hi, all,

In a nutshell:

I downloaded new Site Builder, and then one by one disabled old SB modules before activating new SB.

Quickly realised that I was going to need to go back to old SB (I think I need to export the old setup to bring into the new one).

You don't - the new SB will import the data from the old SB.

Quote:
I activated the maintenance mode, disabled new SB, and began re activating old SB modules.

I think I had done the first one, and on saving changes to the second one, I was faced with the header, the menu, and a blank white screen. The 'admin' link by the ACP menu had disappeared, so I manually logged out to try logging in again - and I can't - it's just the header, the menu and a blank white screen...

Help!

Look in your PHP Error log - sounds like something is trying to be called that is not loaded or available.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
iamtimbo
@iamtimbo
10 years ago
301 posts
I can't see anything bar the header and the white page.
iamtimbo
@iamtimbo
10 years ago
301 posts
Ok - pages seem to be loading now.
brian
@brian
10 years ago
10,148 posts
iamtimbo:
Ok - pages seem to be loading now.

Glad to hear it.. ;)


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
iamtimbo
@iamtimbo
10 years ago
301 posts
Having another bash. You say the new SB will import the old stuff - do I have to do anything at all? It's currently not showing any pages, menus or anything from the old SB.

EDIT: I realise it's still in beta - should I wait for a bit (I have so many menus - over 90!) before I jump? I'd like to do it soon, though, as the iOS users are having a tough time bearing with the workaround. I should have mentioned that I'm on the Slate skin, and all up to date....
updated by @iamtimbo: 05/19/15 02:42:09PM
iamtimbo
@iamtimbo
10 years ago
301 posts
Looking through the other posts, I wondered if I should let SB disable the old modules during the integrity check (as opposed to me doing it before activating the new SB module). The integrity check has been verifying jrSiteBuilder for around half an hour now (Integrity Check normally takes around 5 minutes) - and I have an error in the logs:

(2015-05-19T22:57:14+01:00.0.22252800 : 0)-(mem: 22544384)-(pid: 10595)-(ip: 94.175.19.254)-(user: admin)-(uri: ourtownstory.co.uk/core/integrity_check_save/__ajax=1) |Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1', '3-6-3', 'all', 'admin\'') ON DUPLICATE KEY UPDA' at line 2|

(2015-05-19T22:57:14+01:00.0.22252800 : 0)-(mem: 22544384)-(pid: 10595)-(ip: 94.175.19.254)-(user: admin)-(uri: ourtownstory.co.uk/core/integrity_check_save/__ajax=1) |INSERT INTO jr_jrsitebuilder_page (page_enabled, page_uri, page_active, page_layout, page_groups, page_title) VALUES ('1', '/admin'', '1', '3-6-3', 'all', 'admin\'') ON DUPLICATE KEY UPDATE page_enabled = page_enabled|

Shall I leave it to carry on, or has it stalled?
updated by @iamtimbo: 05/19/15 03:26:05PM
michael
@michael
10 years ago
7,768 posts
its stalled. The issue in your SQL seams to be that you have a user or url that is
admin'

I didn't think that was possible. Thought there were checks in place for that not to happen.

What I would do is, hopefully you have a backup. If you do, go import that. If you don't then make one first.
* turn all the old site builder system back on.
* enable MENUS
* enable PANELS
* enable WIDGETS
* (if your using it) enable CONSTRUCTION KIT
* disable the new site builder

-- now make a backup
ACP -> SITE BUILDER -> PANELS -> TOOLS -> EXPORT
* Export everything to a .json file.
* download the .json file. (this is your backup)

-- probably best to stop here for now, if it doesnt work with the latest version, then its going to not work again if you do it again.

I'll check out the SiteBuilder system to see why it could be failing. Then get some checks in place.

If you send me that .json file to support at jamroom I can use it to test against to make sure its all ok to save you the hassle for next time if you like. If it doesnt attach as a .json file, package it in a .zip file, they attach.
iamtimbo
@iamtimbo
10 years ago
301 posts
Ah - ok!

I've successfully reverted. You were right - there was a page created called admin' - I expect I was logged in as admin, typed sitename.com/admin and skimmed the ' as I hit enter. The page then got created, and stuffed up the process as above.

I have deleted that page, and created a backup, which I'll email over to you when I'm on the PC in a bit. Do you think it's still not worth trying again with the new SB now that the admin' page is gone?
michael
@michael
10 years ago
7,768 posts
send me that file. I'll try and make sure that next time its un-able to cause a problem, then release a newer version with that check in place, then you wont need to worry. :)
iamtimbo
@iamtimbo
10 years ago
301 posts
Hi there - sorry, real life getting in the way! Here's the file......
updated by @iamtimbo: 05/21/15 12:09:52AM
michael
@michael
10 years ago
7,768 posts
Somethings up, need to figure out what. Its only importing to LDN and not including WALES. Looking for why now.
iamtimbo
@iamtimbo
10 years ago
301 posts
Ah - ok - thank you for that - we'd better not upset the Welsh......
michael
@michael
10 years ago
7,768 posts
1.0.7 is in the marketplace now. It should do the job correctly.
iamtimbo
@iamtimbo
10 years ago
301 posts
Brilliant - thanks, Michael, I'll give it a whirl this afternoon.
iamtimbo
@iamtimbo
10 years ago
301 posts
Hi, Michael,

I gave that a try, but it didn't bring everything in - see the screengrab.....you can see how many there should be at ourtownstory.co.uk

Tim
menubuilder.PNG.png
menubuilder.PNG.png  •  34KB


updated by @iamtimbo: 05/21/15 03:29:16PM
iamtimbo
@iamtimbo
10 years ago
301 posts
I've looked at the json file in notepad, and everything sems to be in that (as far as I can tell) - I've done it again, just in case, but the file is the same.
updated by @iamtimbo: 05/21/15 03:33:26PM
michael
@michael
10 years ago
7,768 posts
Thats the menu editor, I didn't check there, just the import feature. Could be a limit issue on there from the new system. Checking it out now.

--edit--
Its looking ok for me here in the menu editor. (screenshot)

What is not showing up for you? Can you locate which entry its hanging up on? Any error logs?

I'll try a DB export of your site and check with that.
updated by @michael: 05/21/15 08:13:06PM
iamtimbo
@iamtimbo
10 years ago
301 posts
Hi Michael - got your note - thanks for looking into all that - hope they get it sorted.

For reference, ourtownstory is registered with GoDaddy - it's just parked on the iamtimbo one in the cPanel. The name servers issue will be becaue of Cloudflare, I expect. I'll change the pw etc....

Re the last post, it doesn't hang at all - it just only outputs the menus in the screenshot.
updated by @iamtimbo: 05/22/15 12:24:58AM
michael
@michael
10 years ago
7,768 posts
I haven't been able to get a DB dump yet, so haven't been able to progress. Could you do a DB export into a .sql file of your jamroom DB from the server control panel (if there is one, thinking phpmyadmin if its there.) and send that to me.

Maybe they get it fixed, maybe they don't, its gone from:
* Sajan ->
* Paul ->
* Samuel ->
* Shakir

So we'll see....

If you can get that .sql file, don't attach it to the forums here, send it to support at jamroom because it will have user-data in it.
michael
@michael
10 years ago
7,768 posts
No luck finding the source of the "Invalid CSRF token." issue. please send me a db export.
iamtimbo
@iamtimbo
10 years ago
301 posts
Ok - I'll have a bash at that, and send it through.
michael
@michael
10 years ago
7,768 posts
steps should be:
* Login to cpanel
* click on PhpMyAdmin
* export -> custom -> (select the jamroom database) -> GO

That pops up either a .sql file or a .zip file for download. Thats what I'm after.
iamtimbo
@iamtimbo
10 years ago
301 posts
Ok - it's downloading now - it's big (580MB) - so taking a while. Will send when done. Or find somewhere to put it!

UPDATE: It's timing out because of the size/slowness of Arvixe. I'm getting the error: Your export is incomplete, due to a low execution time limit at the PHP level.

I'll talk to Arvixe, and see what I can do.
updated by @iamtimbo: 05/22/15 03:04:07AM
iamtimbo
@iamtimbo
10 years ago
301 posts
Arvixe have downloaded it for me, and I've emailed the link to support - let me know that you've got it and it works....
michael
@michael
10 years ago
7,768 posts
Got it, thanks.
michael
@michael
10 years ago
7,768 posts
Got the dev setup setup and can see it happening on your setup. Trying to figure out what the issue is now.

Sorry for the delay.
michael
@michael
10 years ago
7,768 posts
ok, got it. The reason it was out with the menu items was that on your system you'd added some menu items, and deleted some others.

The system expected the item_id's to line up:
1 -> 1
2 -> 2
....
but on your system it started with 4 so it was going
4 -> 1
....

when transferred. This made the parent id for the menu items be the wrong one. Its fixed now in 1.0.8 in the marketplace.

Think you'll be good now.
iamtimbo
@iamtimbo
10 years ago
301 posts
Ah - that's great - thank you - sorry, I think inadvertently unsubscribed from this thread and didn't see the update!

I'll have a bash tonight.....
iamtimbo
@iamtimbo
10 years ago
301 posts
Evening! I'm sorry to have to report that I got the same result this time round with the menu builder. I haven't attached a new screenshot, as its identical to the one above.

In good news, though, the old site builder pages seemed to come through, although they were offset to the right of the network logo. I'm assuming, though, that's because the menu isn't appearing.

Sorry to be the bearer of boring news...
michael
@michael
10 years ago
7,768 posts
I know what the problem is, its that your importing tables are already full with stuff.

Could I have access to PhpMyAdmin on your server please. I'll clear out the tables for the new site builder system so the old system can be imported.
iamtimbo
@iamtimbo
10 years ago
301 posts
That sounds reasonable - I'll email details....
michael
@michael
10 years ago
7,768 posts
Yup, got that. hold on.
michael
@michael
10 years ago
7,768 posts
Ok, give the upgrade another go now.
iamtimbo
@iamtimbo
10 years ago
301 posts
Ok - success! All the menus are in - they're not displaying, but they're in - I'm investigating the not showing issue....

-----------
EDIT - no joy getting them to display - did try adding a fresh menu to the list, but that didn't show either. It has definitely brought in the old menus, though, so that's great news.

Any thoughts about why the menu isn't showing would be welcome...!
updated by @iamtimbo: 05/29/15 07:56:10AM
michael
@michael
10 years ago
7,768 posts
The function to use to get the menus out to the header.tpl file (or header_menu_desktop.tpl file) is:
{jrSiteBuilder_menu}

The default output format expects the UL to already be there, so its injecting into an existing menu location.

To put it all by itself where it controls all entries like as a replacement for the slate skin's bar menu, then the structure would be:
<div id="jrmenu_content">
    <nav id="jrmenu-wrap">
        <ul id="jrmenu">
            {jrSiteBuilder_menu}
        </ul>
    </nav>
</div>

Good that we're getting closer. :)
iamtimbo
@iamtimbo
10 years ago
301 posts
I'll have a bash at that on Friday and let you know how I get on - thank you! :)
updated by @iamtimbo: 06/02/15 03:16:14PM