500 after upgrade 3.75. to 38.3. in article manager

Need help upgrading your Joomla! website or converting to Joomla! 3.x? Please consider the availability of third-party templates and extensions when deciding which Joomla version to use.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
tblueweb
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sun Sep 30, 2012 4:15 pm

500 after upgrade 3.75. to 38.3. in article manager

Postby tblueweb » Mon Nov 13, 2017 9:28 pm

I am getting a 500 error in the article manager after the upgrade. Everything else looks ok.

"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 'AND (a.title LIKE '%menu%' OR a.alias LIKE '%menu%') ORDER BY a.id DESC LIMIT 20' at line 10 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 'AND (a.title LIKE '%menu%' OR a.alias LIKE '%menu%')' at line 9"

php 5.6 mysql 5.6

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 33407
Joined: Sat Apr 05, 2008 9:58 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby Webdongle » Mon Nov 13, 2017 10:24 pm


tblueweb
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sun Sep 30, 2012 4:15 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby tblueweb » Mon Nov 13, 2017 10:52 pm

Last PHP Error(s) Reported :: Forum Post Assistant (v1.3.5) : 13th November 2017 wrote: in Unknown on line 0
Forum Post Assistant (v1.3.5) : 13th November 2017 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.8.2-Stable (Amani) 7-November-2017
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.8
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 1 | .htaccess/web.config: Yes | GZip: 0 | Cache: 0 | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: 0 | FTP Layer: 0 | Proxy: 0 | LiveSite: | Session lifetime: 90 | Session handler: database | Shared sessions: 0 | SSL: 0 | FrontEdit: 1 | Error Reporting: development | Site Debug: 1 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 3.10.0-614.10.2.lve1.4.50.el6h.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes

PHP Configuration :: Version: 5.6.32 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 22527 | Log Errors To: error_log | Last Known Error: 13th November 2017 15:51:04. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 50M | Max. POST Size: 50M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 128M

MySQL Configuration :: Version: 5.6.32-78.1-log (Client:5.6.32-78.1) | Host: --protected-- (--protected--) | Collation: latin1_swedish_ci (Character Set: latin1) | Database Size: 21.66 MiB | #of Tables:  104
Detailed Environment :: wrote:PHP Extensions :: Core (5.6.32) | date (5.6.32) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7-dev) | zlib (2.0) | bcmath () | bz2 () | calendar () | ctype () | curl () | dba () | dom (20031129) | enchant (1.1.0) | hash (1.0) | fileinfo (1.0.5) | filter (0.11.0) | ftp () | gd () | gettext () | SPL (0.2) | iconv () | session () | intl (1.1.0) | json (1.2.1) | mbstring () | mcrypt () | standard (5.6.32) | mysql (1.0) | mysqli (0.1) | odbc (1.0) | mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $) | PDO (1.0.4dev) | pdo_dblib (1.0.1) | PDO_ODBC (1.0.1) | pgsql () | Phar (2.0.2) | posix () | pspell () | Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $) | imap () | SimpleXML (0.1) | snmp (0.1) | soap () | sockets () | exif (1.4 $Id: 1c8772f76be691b7b3f77ca31eb788a2abbcefe5 $) | tidy (2.0) | tokenizer (0.1) | wddx () | xml () | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.12.5) | cgi-fcgi () | mhash () | Zend Engine (2.6.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) |

Elevated Permissions (First 10) :: naturals/media/css/ (777) | naturals/media/css_secure/ (777) | naturals/media/js/ (777) | naturals/var/cache/mage--2/ (777) | naturals/var/cache/mage--3/ (777) | naturals/var/cache/mage--4/ (777) | naturals/var/cache/mage--7/ (777) | naturals/var/cache/mage--9/ (777) | naturals/var/cache/mage--a/ (777) | naturals/var/cache/mage--f/ (777) |
Database Information :: wrote:Database statistics :: Uptime: 5152255 | Threads: 2 | Questions: 1509166729 | Slow queries: 55186 | Opens: 7242017 | Flush tables: 2 | Open tables: 4096 | Queries per second avg: 292.913 |
Extensions Discovered :: wrote:Components :: SITE :: WF_TABLE_TITLE (2.6.16) 1 | WF_STYLESELECT_TITLE (2.6.16) 1 | WF_CLEANUP_TITLE (2.6.16) 1 | WF_STYLE_TITLE (2.6.16) 1 | WF_SEARCHREPLACE_TITLE (2.6.16) 1 | WF_BROWSER_TITLE (2.6.16) 1 | WF_EMOTIONS_TITLE (2.6.16) 1 | WF_HR_TITLE (2.6.16) 1 | WF_LINK_TITLE (2.6.16) 1 | WF_ARTICLE_TITLE (2.6.16) 1 | WF_LAYER_TITLE (2.6.16) 1 | WF_MEDIA_TITLE (2.6.16) 1 | WF_FONTSIZESELECT_TITLE (2.6.16) 1 | WF_TEXTCASE_TITLE (2.6.16) 1 | WF_VISUALCHARS_TITLE (2.6.16) 1 | WF_CONTEXTMENU_TITLE (2.6.16) 1 | WF_FORMATSELECT_TITLE (2.6.16) 1 | WF_FONTCOLOR_TITLE (2.6.16) 1 | WF_AUTOSAVE_TITLE (2.6.16) 1 | [Do not buy our kitchens!] (2.6.16) 1 | WF_ANCHOR_TITLE (2.6.16) 1 | WF_PRINT_TITLE (2.6.16) 1 | WF_SPELLCHECKER_TITLE (2.6.16) 1 | WF_FULLSCREEN_TITLE (2.6.16) 1 | WF_CHARMAP_TITLE (2.6.16) 1 | WF_XHTMLXTRAS_TITLE (2.6.16) 1 | WF_VISUALBLOCKS_TITLE (2.6.16) 1 | WF_NONBREAKING_TITLE (2.6.16) 1 | WF_INLINEPOPUPS_TITLE (2.6.16) 1 | WF_PREVIEW_TITLE (2.6.16) 1 | WF_IMGMANAGER_TITLE (2.6.16) 1 | WF_SOURCE_TITLE (2.6.16) 1 | WF_CLIPBOARD_TITLE (2.6.16) 1 | WF_LISTS_TITLE (2.6.16) 1 | WF_DIRECTIONALITY_TITLE (2.6.16) 1 | WF_FONTSELECT_TITLE (2.6.16) 1 | WF_LINKS_JOOMLALINKS_TITLE (2.6.16) 1 | WF_AGGREGATOR_VIMEO_TITLE (2.6.16) 1 | [youtube] (2.6.16) 1 | WF_AGGREGATOR_VINE_TITLE (2.6.16) 1 | WF_AGGREGATOR_DAILYMOTION_TITL (2.6.16) 1 | WF_POPUPS_WINDOW_TITLE (2.6.16) 1 | WF_POPUPS_JCEMEDIABOX_TITLE (2.6.16) 1 | WF_LINK_SEARCH_TITLE (2.6.16) 1 | WF_FILESYSTEM_JOOMLA_TITLE (2.6.16) 1 | com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
Components :: ADMIN :: com_plugins (3.0.0) 1 | Admintools (4.0.1) 1 | COM_CMC (4.1.0) 1 | com_search (3.0.0) 1 | com_associations (3.7.0) 1 | com_users (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_admin (3.0.0) 1 | COM_JCE (2.6.16) 1 | com_media (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 | com_postinstall (3.2.0) 1 | com_modules (3.0.0) 1 | com_menus (3.0.0) 1 | com_ajax (3.2.0) 1 | com_banners (3.0.0) 1 | com_fields (3.7.0) 1 | Akeeba (5.6.0) 1 | com_categories (3.0.0) 1 | com_installer (3.0.0) 1 | COM_GANTRY (4.1.33) 1 | com_tags (3.1.0) 1 | com_contenthistory (3.2.0) 1 | RokSprocket (2.1.21) 1 | com_languages (3.0.0) 1 | com_login (3.0.0) 1 | com_redirect (3.0.0) 1 | com_templates (3.0.0) 1 | Cmsupdate (1.2.4) 1 | com_cache (3.0.0) 1 | com_messages (3.0.0) 1 | com_finder (3.0.0) 1 | com_config (3.0.0) 1 | com_checkin (3.0.0) 1 | com_weblinks (3.5.0) 1 | com_content (3.0.0) 1 | com_gantry5 (5.2.13) 1 | com_newsfeeds (3.0.0) 1 |

Modules :: SITE :: RokSprocket Module (2.1.21) 1 | mod_tags_popular (3.1.0) 1 | mod_banners (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_category (3.0.0) 1 | Xpert Scroller (3.10-1-GFF3CA) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_login (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_gantry5_particle (5.2.13) 1 | mod_whosonline (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_cmc (4.1.0) 1 | mod_articles_news (3.0.0) 1 | RokNavMenu (2.0.9) 1 | mod_users_latest (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_weblinks (3.5.0) 1 | mod_menu (3.0.0) 1 | mod_finder (3.0.0) 1 |
Modules :: ADMIN :: mod_toolbar (3.0.0) 1 | mod_status (3.0.0) 1 | mod_login (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_title (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_version (3.0.0) 1 | mod_sampledata (3.8.0) 0 | mod_popular (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_submenu (3.0.0) 1 |

Plugins :: SITE :: plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_content_pagebreak (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | Content - RokBox (2.0.13) 1 | Content - RokInjectModule (1.7) 1 | plg_content_joomla (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_pagenavigation (3.0.0) 1 | plg_content_jce (2.6.16) 1 | smartresizer (1.19) 1 | plg_content_geshi (2.5.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | Community - CMC Registration p (4.1.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_weblinks (3.5.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | User - CMC Registration plugin (-) 0 | plg_user_profile (3.0.0) 0 | plg_search_contacts (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_search_weblinks (3.5.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_gantry5_preset (5.2.13) 1 | PLG_QUICKICON_CMSUPDATE (1.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_jce (2.6.0-pro-bet) 1 | plg_quickicon_gantry5 (5.2.13) 1 | plg_quickicon_akeebabackup (1.0) 0 | plg_quickicon_phpversioncheck (3.7.0) 1 | CMC - Ecom360 Hika (4.1.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | System - RokBox (2.0.13) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_logout (3.0.0) 1 | PLG_SYSTEM_METAGENERATOR (2.0.4) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK_T (1.1) 1 | System - RokExtender (2.0.0) 1 | System - CMC Ecom360 Payplans (4.1.0) 0 | System - CMC Mailchimp ecommer (4.1.0) 1 | plg_system_jce (2.6.16) 1 | plg_system_cache (3.0.0) 0 | System - One Click Action (2.1) 0 | System - Admin Tools Update Em (1.0) 1 | System - Marco's SQL Injection (1.2) 1 | System - CMC ecom360 Matukio (4.1.0) 0 | System - CMC Ecom360 Virtuemar (4.1.0) 1 | PLG_CMSUPDATEEMAIL (1.0) 1 | System - CMC Ecom360 Redshop (4.1.0) 0 | System - Google Maps (3.5) 1 | plg_system_gantry5 (5.2.13) 1 | plg_system_remember (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | PLG_SYSTEM_AKGEOIP (1.0.4) 0 | System - RokSprocket (2.1.21) 1 | System - Admin Tools Joomla! U (1.0) 1 | plg_system_stats (3.5.0) 1 | System - CMC Ecom360 Akeebasub (4.1.0) 1 | plg_system_p3p (3.0.0) 1 | System - Admin Tools (4.0.1) 1 | PLG_SYSTEM_BACKUPONUPDATE_TITL (3.7) 1 | plg_system_log (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_fields (3.7.0) 1 | System - RokCommon (3.2.5) 1 | System - Gantry 4 (4.1.33) 1 | plg_system_languagecode (3.0.0) 0 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | Button - RokBox (2.0.13) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_extension_jce (2.6.16) 1 | plg_editors_jce (2.6.16) 1 | plg_editors_codemirror (5.30.0) 1 | plg_editors_tinymce (4.5.7) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_jce (2.6.16) 1 | plg_installer_webinstaller (1.1.1) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 |
Templates Discovered :: wrote:Templates :: SITE :: protostar (1.0) 1 | beez_20 (2.5.0) 1 | atomic (2.5.0) 1 | beez3 (3.1.0) 1 | beez5 (2.5.0) 1 | rt_cygnet (1.0) 1 |
Templates :: ADMIN :: hathor (3.0.0) 1 | bluestork (2.5.0) 1 | isis (1.0) 1 |

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 33407
Joined: Sat Apr 05, 2008 9:58 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby Webdongle » Tue Nov 14, 2017 1:28 am

You have folders 777 they should be 755

tblueweb
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sun Sep 30, 2012 4:15 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby tblueweb » Tue Nov 14, 2017 1:32 am

Those folder "naturals' have nothing to do with the joomla site. And not used

tblueweb
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sun Sep 30, 2012 4:15 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby tblueweb » Tue Nov 14, 2017 1:48 am

So riddle me this.. I change the perms on that folder Tre. And the problem goes away BUT those folder s hav nothing to do whatever with the joomla install.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 33407
Joined: Sat Apr 05, 2008 9:58 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby Webdongle » Tue Nov 14, 2017 2:23 am

I would suspect a hack but I'm an old synic

tblueweb
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sun Sep 30, 2012 4:15 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby tblueweb » Tue Nov 14, 2017 3:38 pm

You couldn't be more cynical than me. I doubt a hack. Its a puzzle however all is well. Thanks much.

frostmakk
Joomla! Apprentice
Joomla! Apprentice
Posts: 35
Joined: Sun Dec 28, 2014 9:30 am

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby frostmakk » Tue Nov 14, 2017 4:03 pm

Maybe not relevant, but this is a small part of what my host writes about file/folder permissions.
On our web servers, PHP uses uWSGI with register_globals=Off. PHP programs run with your Unix/FTP username's permissions, and not as a part of the webserver. You will get an "Internal server error" message if other users than your Unix user can write to these files.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 33407
Joined: Sat Apr 05, 2008 9:58 pm

Re: 500 after upgrade 3.75. to 38.3. in article manager

Postby Webdongle » Tue Nov 14, 2017 9:43 pm

Ah a safety measure


Return to “Migrating and Upgrading to Joomla! 3.x”

Who is online

Users browsing this forum: No registered users and 7 guests