Query failed

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
njflynn
Regular
Posts: 10
Joined: Tue Jun 16, 2015 3:19 pm

Query failed

Post by njflynn »

Could someone please help me?! I don't know what happened to my website or how to make it better. (http://www.fincaretama.com) Only the following is displayed and I don't know what it means:


Query failed:

SELECT
multilingual_body.value AS multilingual_body,
multilingual_extended.value AS multilingual_extended,
multilingual_title.value AS multilingual_title,
ep_sticky.value AS orderkey,

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.username AS loginname,
a.email
, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid

LEFT OUTER JOIN serendipity_entryproperties multilingual_body
ON (e.id = multilingual_body.entryid AND multilingual_body.property = 'multilingual_body_fr')
LEFT OUTER JOIN serendipity_entryproperties multilingual_extended
ON (e.id = multilingual_extended.entryid AND multilingual_extended.property = 'multilingual_extended_fr')
LEFT OUTER JOIN serendipity_entryproperties multilingual_title
ON (e.id = multilingual_title.entryid AND multilingual_title.property = 'multilingual_title_fr') LEFT OUTER JOIN serendipity_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN serendipity_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN serendipity_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1434460200 AND (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1)) AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true') AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 1

/ Table './fincaret_casaabuela/serendipity_entryproperties' is marked as crashed and should be repaired
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Query failed

Post by Timbalu »

Code: Select all

/ Table './fincaret_casaabuela/serendipity_entryproperties' is marked as crashed and should be repaired
Open up PhpMyAdmin or your favourite Database Admin Tool, like Adminer or something, and
REPAIR the mentioned table. It normally is a command.
In PhpMyAdmin: Open up the database 'fincaret_casaabuela' and check mark the 'serendipity_entryproperties' table. Down under you can select 'Repair Table' for the marked table.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
njflynn
Regular
Posts: 10
Joined: Tue Jun 16, 2015 3:19 pm

Re: Query failed

Post by njflynn »

Timbalu, thanks for your reply I really appreciate it as I'm panicking a bit now. Unfortunately to make matters worse for me, when I log into fincaretama admin page it all comes up in french and I have no idea what to select. Is there anyway I could change the language to English? My website is in 4 languages and was created by someone in serendipity. I'm afraid I can only do basic admin so please explain it a bit more what do I need to do. Thanks so much
njflynn
Regular
Posts: 10
Joined: Tue Jun 16, 2015 3:19 pm

Re: Query failed

Post by njflynn »

Have just noticed that when I click on 'edit page' only the same 'Query Failed' page opens up.
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Query failed

Post by Timbalu »

njflynn wrote:when I log into fincaretama admin page it all comes up in french and I have no idea what to select
This is not what I wrote!

Serendipity uses a Database. Most commonly MySQL. There are extra tools to administrate such databases, which have nothing to do with the Serendipity Software itself.

If your site is hosted by a hoster, please ask the one to quickly do the TABLE REPAIR for you, or give you access to such a tool, like PhpMyAdmin or Adminer.

Don't panic! Such broken tables can happen and normally are not an issue of the Software using it directly. Therefore is the command REPAIR TABLE: https://dev.mysql.com/doc/refman/5.1/en ... table.html
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Query failed

Post by Timbalu »

Ai - I read fresh instead of french! :) To change the language, open up the Serendipity backend, click on 'Réglages personnels' and choose the english language in the 'Langue' select box. Submit.
After some other next click inside the backend the lang will change.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
njflynn
Regular
Posts: 10
Joined: Tue Jun 16, 2015 3:19 pm

Re: Query failed

Post by njflynn »

Thanks Ian but I'm afraid it didn't work. It's keep asking me to change my password which I don't want to do.
Attached a screenshot of it:
Unfortunately as I don't speak french and my serendipity problem solving knowledge is limited I find it rather impossible to solve my problem. :(
Attachments
fr serendipity issue.jpg
fr serendipity issue.jpg (239.78 KiB) Viewed 6183 times
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Query failed

Post by Timbalu »

Ok - that is even more odd - but I am pretty sure - if not being something worse like a hack - this is a matter of using a very old and outdated version (Serendipity 1.3.1), missing some fixes for these password and language issues.

But first, fix the crashed database table, like I recommended to do.

Then make a full backup of the Database, which holds all the Serendipity tables, and also the physical installation in your web.

Then upgrade your blog with Serendipity 1.7.8
http://sourceforge.net/projects/php-blo ... &download=
or even below with v.1.6.2, since you only have PHP 5.2.x available.

If your hoster increases the PHP version number and most possible the Database version from v.4.x to v.5.x, you can even upgrade to the current Serendipity version, after having migrated the database first.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Query failed

Post by Timbalu »

The french red error message you get means:
You did not specify the right old password, and are not authorized to change the new password. Your settings were not saved.
I assume you either are

1. not the blogs root admin, or
2. you or your Browser added something into one or both of the two password fields.
3. Or it is a matter of that old Serendipity Version
4. "Or someone has reset the password...."
5. Or wrong usage .... it simply is this: :)

I don't remember how this was done in 1.3.1..., but normally, opening the personal preferences page, you have no visible input in both password fields!
As i can "see" on your screenshot, you have something set in the first password field. (and wiped it out for the screenshot). This should be empty! Both fields are only used, if you want to reset your password. First filled with the new password, second with the old password.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
njflynn
Regular
Posts: 10
Joined: Tue Jun 16, 2015 3:19 pm

Re: Query failed

Post by njflynn »

Hi Ian, I have contacted my host and they have reset my website to yesterday's settings. At least it's back up and running again. Thanks for all your help.
Post Reply