Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[wpml compatibility] No Page Found #71

Open
holy88 opened this issue Jan 30, 2015 · 12 comments
Open

[wpml compatibility] No Page Found #71

holy88 opened this issue Jan 30, 2015 · 12 comments
Assignees

Comments

@holy88
Copy link

holy88 commented Jan 30, 2015

Plugin + addons activated ( WP 4.1 - Custom Theme )

In "Pages" and in "Posts":

No Page Found / No Post Found

@julien731
Copy link
Member

Humm not sure I understand correctly. Could you give a little more details, possibly screenshot? Also, have you tried refreshing the permalinks?

@holy88
Copy link
Author

holy88 commented Jan 30, 2015

I'm sorry for my terrible english ..

I had no problems with a test installation ..

But when i tryed to use it on another website with or without addons
"pages" and "Posts" disappears. The pages exist i can navigate and i can
modify them, but i can't see them in the backend

http://www.domain.it/wp-admin/edit.php?post_type=page

And same for woocommerce products

:/

Thanks

Update:

Without WPML (translation plugin) all is working fine (...).

WordPress database error: [Unknown column '1LEFT' in 'on clause']
SELECT wp_posts.* FROM wp_posts JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = 'post_page' JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1LEFT JOIN ( SELECT MAX(ID) as child_ID, post_parent FROM wp_posts WHERE post_type = 'ticket_reply' AND post_status = 'unread' GROUP BY post_parent ) sl ON wp_posts.ID = sl.post_parent LEFT JOIN wp_posts wp1 on sl.child_ID = wp1.ID WHERE 1=1 AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) AND t.language_code='it' ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Unknown column '1LEFT' in 'on clause']
SELECT wp_posts.* FROM wp_posts JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = 'post_page' JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1LEFT JOIN ( SELECT MAX(ID) as child_ID, post_parent FROM wp_posts WHERE post_type = 'ticket_reply' AND post_status = 'unread' GROUP BY post_parent ) sl ON wp_posts.ID = sl.post_parent LEFT JOIN wp_posts wp1 on sl.child_ID = wp1.ID WHERE 1=1 AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) AND t.language_code='it' ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

WordPress database error: [Unknown column '1LEFT' in 'on clause']
SELECT wp_posts.* FROM wp_posts JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = 'post_page' JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1LEFT JOIN ( SELECT MAX(ID) as child_ID, post_parent FROM wp_posts WHERE post_type = 'ticket_reply' AND post_status = 'unread' GROUP BY post_parent ) sl ON wp_posts.ID = sl.post_parent LEFT JOIN wp_posts wp1 on sl.child_ID = wp1.ID WHERE 1=1 AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish')) AND t.language_code='it' ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

Page

WordPress database error: [Unknown column '1LEFT' in 'on clause']
SELECT wp_posts.* FROM wp_posts JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = 'post_page' JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1LEFT JOIN ( SELECT MAX(ID) as child_ID, post_parent FROM wp_posts WHERE post_type = 'ticket_reply' AND post_status = 'unread' GROUP BY post_parent ) sl ON wp_posts.ID = sl.post_parent LEFT JOIN wp_posts wp1 on sl.child_ID = wp1.ID WHERE 1=1 AND wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'queued' OR wp_posts.post_status = 'processing' OR wp_posts.post_status = 'hold' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') AND t.language_code='it' ORDER BY wp_posts.menu_order, wp_posts.post_date DESC

Post

WordPress database error: [Unknown column '1LEFT' in 'on clause']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = 'post_post' JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1LEFT JOIN ( SELECT MAX(ID) as child_ID, post_parent FROM wp_posts WHERE post_type = 'ticket_reply' AND post_status = 'unread' GROUP BY post_parent ) sl ON wp_posts.ID = sl.post_parent LEFT JOIN wp_posts wp1 on sl.child_ID = wp1.ID WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'queued' OR wp_posts.post_status = 'processing' OR wp_posts.post_status = 'hold' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') AND t.language_code='it' ORDER BY wp_posts.menu_order, wp_posts.post_date DESC LIMIT 0, 20

2015-01-30 18:17 GMT+01:00 Julien Liabeuf notifications@github.com:

Humm not sure I understand correctly. Could you give a little more
details, possibly screenshot? Also, have you tried refreshing the
permalinks?


Reply to this email directly or view it on GitHub
#71 (comment)
.

@holy88 holy88 changed the title No Page Found [wpml compatibility] No Page Found Feb 1, 2015
@julien731 julien731 self-assigned this Feb 3, 2015
@julien731
Copy link
Member

I have WPML 3.1.8.4 installed along with the development version of Awesome Support and everything is fine. What version of WPML are you using? Any tips on how to re-create the issue?

@holy88
Copy link
Author

holy88 commented Feb 10, 2015

3.1.8.4

https://wpml.org/forums/topic/wpml-bugs-urgent-need-fix/

There's some other threads on wpml support like this one and mine.

You don't have problems in Posts/pages ? ( they simpli disappear from the
wp dash, but they keep existing )

2015-02-10 8:37 GMT+01:00 Julien Liabeuf notifications@github.com:

I have WPML 3.1.8.4 installed along with the development version of
Awesome Support and everything is fine. WHat version of WPML are you using?
Any tips on how to re-create the issue?


Reply to this email directly or view it on GitHub
#71 (comment)
.

@julien731
Copy link
Member

No problem on my side.

image

Is there any specific settings for WPML that would trigger the issue? I have just activated the plugin, didn't touch anything else.

@holy88
Copy link
Author

holy88 commented Feb 10, 2015

screen

Looks like wpml is not activated, there's no translation Option in your
screen (?)

Anyway i have all the post/products translated.

@julien731
Copy link
Member

I think the plugin isn't active because I don't have a license key. I'm trying to get in touch with them to know how to get a developer version of their plugin.

@siamkreative
Copy link
Contributor

Follow up on this @julien731 ?

@ahorndesign
Copy link

I would like to confirm the issue. We are evaluating your plugin and were about to implement it on numerous sites and purchase paid licenses when we ran into the incompatibility.
I first noticed the issues last week. We installed your plugin on an existing site and upon activating it we were not able to see any pages in the backend.
I wanted to reevaluate this and did the following today:

  • installed a clean WP
  • installed WPML and set an additional language
  • added Awesome Support
    Once AS has been activated all pages disappeared from the backend (Just to avoid misunderstandings -by pages I refer to posts of the "pages" post type, built into WordPress and not to any admin screens). The links to switch between languages at the top of the list of pages are inactive, even hough the post count displays correctly next to them. Newly aded pages are also not appearing.

@ahorndesign
Copy link

BTW, in the screenshot above you have enabled WPML, but either pages are not set as translatable or you have not added a second language to the site (otherwise you would be able to see a langiages dropdown in the admin bar and links for the different translations under "All" and "Published" on the pushes list screen.

@julien731
Copy link
Member

Thanks for your report. We will definitely try to get a hold on the WPML team and try to figure out what's wrong.

@julien731
Copy link
Member

The issue has been reported as resolved with the latest version of both WPML and Awesome Support.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants