The identifier id is missing for a query of Concrete\Core\Entity\Express\Form

Permalink Browser Info Environment
The identifier id is missing for a query of Concrete\Core\Entity\Express\Form

Type: Discussion
Status: In Progress
View Replies:
c5box replied on at Permalink Reply
c5box
HI!

I may need a bit more info to help you out. :)

Did this happen during theme installation? When did the error occur? Can you try creating a new form and deleting the old one?

Kind regards,
James
skip77 replied on at Permalink Reply
This happened when adding a express block and disabled the home area in the admin area.
skip77 replied on at Permalink Reply
How can I get this back so I can edit the homepage?
c5box replied on at Permalink Reply
c5box
Can you try going to your dashboard and removing the block from the stacks/global blocks menu?
skip77 replied on at Permalink Reply
It messed up the homepage dashboard

Sent from my iPhone

> On Jun 15, 2017, at 7:33 PM, concrete5 Community <[email protected]> wrote:
c5box replied on at Permalink Reply
c5box
Hi,

Sorry but you may need to rollback from a backup db and files to be able to fix this.

Kind regards,
James
skip77 replied on at Permalink Reply
I can't. It won't let me sign in.
skip77 replied on at Permalink Reply
Here's what I get when I try and sign in -

An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE (ak_is_desktop = 1) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND ((p.siteTreeID = ? or p.siteTreeID = 0)) ORDER BY ak_desktop_priority desc' with params [true, 1]: SQLSTATE[HY000]: General error: 145 Table './powertee_site/PageSearchIndex' is marked as crashed and should be repaired
skip77 replied on at Permalink Reply
I have a whole site ready to go live and I can't sign in to the dashboard.

See the error in the previous post.
c5box replied on at Permalink Reply
c5box
Hi

Can you walk me through what happened before you got the error. There is a month and a half gap since you last replied, where you able to fix it then and the error came back? From what I can tell, you might have a corrupted database for one of the core blocks. The best solution here is to restore the SQL from a working backup.

Kind regards,
James
skip77 replied on at Permalink Reply
The first issue - I had to reinstall C5 and your template.
The first issue is caused by dragging a form block to a page. It causes an error and can't be undone. It happened again on this install and I had to create a new homepage and redirect the url to ignore the original homepage.

The current issue is not letting me sign in and is caused by a problem with the search block.

http://www.powertee.com/new_site/index.php/login/authenticate/concr...
user name: admin

password: 12345Sb
c5box replied on at Permalink Reply
c5box
Do you have a backup of your database you can restore from? The error is saying that one of the core concrete5 functions has crashed because of a corrupted database. Also, did you any other addons before this error appeared?
skip77 replied on at Permalink Reply
Where would the back up data base be? The core function was the "search" block. So I need help finding and replacing the data base or replacing code in files to fix this.
c5box replied on at Permalink Reply
c5box
Can your try asking your hosting provider if they made a backup of your website? Most hosting services usually have an automated backup. If you can get this I will try to help you restore from it.
skip77 replied on at Permalink Reply
I will ask. Where are the backups in C5 stored?
c5box replied on at Permalink Reply
c5box
Hi

Unfortunately, c5 does not do or keep backups of the db. Its really up to the user to backup the db.
skip77 replied on at Permalink Reply
The identifier id is missing for a query of Concrete\Core\Entity\Express\Form

The hosting company checked the data base on the server and it is working. What can we do to fix the code? The missing identifier id is what caused the issue with the Express\Form

This is the second time this happened and can't afford to rebuild the site again.
c5box replied on at Permalink Reply
c5box
Hi

The database and the files should all be working if they check. but the problem is your c5 files are not in sync with the db. Usually this happens when you havel an addon and just delete it without properly uninstalling.

The only way you can fix this is by asking your hosting for a backup of the database from when the site was still working. There is no other option I can think of. Even if you switch themes or uninstall any other addons, the site will still spit out that error because it is the core block thats broken.

Again, request for a backup of the database when your site is still functional.

Please let me know when you have it.

Kind regards
James
c5box replied on at Permalink Reply
c5box
It is also quite complicated to restore the database from an sql file if you are not familiar with the system. If you do manage to retrieve the backup but are not given access to your db, you can also ask your hosting to restore it for you. What type of hosting are you using?
skip77 replied on at Permalink Reply
The error says missing id that is from an express/form that was in your template. You can't correct that or take that "form" out from the code in C5? You have an install of pages/code and file loaded on the server and you can't adjust any of these to correct this problem?

I cannot sign into the cos/control panel of C5 install. This issues seem to be from your template that I bought. It got corrupted once and I started over. We are ready to go live and this is the second corruption. I'm losing thousand of dollars on this.
c5box replied on at Permalink Reply
c5box
Concrete5 forms or express forms are all core files. Themes and templates are just HTML/CSS which changes the form appearance. But if you insist on blaming my theme for the corruption then I'll gladly issue you a refund. You can check this by opening the theme files yourself. I wish I could help you fix this by tweaking my theme but thats just not going to work.
skip77 replied on at Permalink Reply
This happened twice with a core file. You're telling me it's a data base issue and my hosting guys say it's a coding issue. All I'm asking for is help with this and asking you to think is another direction to find a solution.
c5box replied on at Permalink Reply
c5box
Yes I understand your problem but the solution for this is to restore the databse from when it was still working. What I meant when I said corruption is that sometimes when you install an addon it will write to the db. But when you delete the addon, c5 will not be able to locate it and it will throw an error. In your case, maybe you created a form and it happen to create a db conflict (by force db delete or some other way). Please believe me that if there was an easy way to fix this, or if this was a theme issue, I would be on it.

If you could tell your hosting to restore the db backup on the day that the site was still workong, this will be fix instantly. And they will be able to do this in a matter of minutes.
skip77 replied on at Permalink Reply
From the hosting company:

It looks like a symlink may have been missing. We were able to get the images on your site to appear, after symlinking application/files to application/controllers/files:
--
(cP/2558/vz62-wa)[email protected] [/home/powertee/public_html/new_site/application]# mv files{,-bak}; ln -s controllers/files; chown -h powertee. files
c5box replied on at Permalink Reply
c5box
Did you move/change the core files? You should backup everything now that its working and try to restore the original core files if possible. Glad you manage to sort this out
skip77 replied on at Permalink Reply
Here's the site link.

http://www.powertee.com/new_site/index.php/powertee...

The ( /powertee is the homepage ) it was "home" but that page got messed up with the "express form" my workaround was to create "powertee" page and make it the new homepage. How do I take this site live. The url needs to behttp://www.powertee.com
c5box replied on at Permalink Reply
c5box
I think you can point the folder directory to the root on the cpanel. But just to make sure, have your hosting assist
skip77 replied on at Permalink Reply
It looks like a symlink may have been missing. We were able to get the images on your site to appear, after symlinking application/files to application/controllers/files:
--
(cP/2558/vz62-wa)[email protected] [/home/powertee/public_html/new_site/application]# mv files{,-bak}; ln -s controllers/files; chown -h powertee. files

How did this break down? was it hosting or C5? again I lost hours on this all for wanting to have a parallax bg.

concrete5 Environment Information

The identifier id is missing for a query of Concrete\Core\Entity\Express\Form

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.