Feil ved aktivering av versjonskontroll i Joomla 3.4

Generelle spørsmål relatert til Joomla! 3.x, som ikke passer i andre forum ovenfor

Moderators: sone12, Per Yngve Berg

Locked
geirl
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Mar 06, 2015 11:56 am

Feil ved aktivering av versjonskontroll i Joomla 3.4

Post by geirl » Fri Mar 06, 2015 12:10 pm

Jeg bruker versjonskontroll i andre Joomla 3.4 versjoner og de fungerer helt fint, men nå har jeg kommet over en installasjon der denne feilmeldingen kommer fram når jeg aktiverer versjonskontroll og når jeg lagrer en artikkel - uansett om den opprettes eller om jeg endrer en eksisterende.

Her er feilmeldingen (vedlagte bilde er av samme feilmelding):
Error
Save failed with the following 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 'AND `sha1_hash` = 'd22709ab5d2c7e80fb904e4a620aa7a6f9bb8f5d' LIMIT 0, 1' at line 3 SQL=SELECT * FROM `iiq72_ucm_history` WHERE `ucm_item_id` = 2 AND `ucm_type_id` = AND `sha1_hash` = 'd22709ab5d2c7e80fb904e4a620aa7a6f9bb8f5d' LIMIT 0, 1

Det er jo sikkert noe databasefeil, men jeg forstår ikke hvordan jeg kan fikse det. Noen her som kan bistå?

Vennlig hilsen
Geir R. Limås
You do not have the required permissions to view the files attached to this post.

User avatar
rued
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4840
Joined: Fri Sep 16, 2005 10:23 pm
Location: Finland / Norway
Contact:

Re: Feil ved aktivering av versjonskontroll i Joomla 3.4

Post by rued » Wed Mar 11, 2015 6:55 am

Hei Geir,

Tipper det er relatert til en eller flere feilede / ikke fullførte oppdateringer, f.eks. ved bruk av eksternt verktøy for oppdatering (eks. Softaculous).

Men siden du ikke opplyser om det må man spørre:
- Har du kjørt databasereparasjonen i Joomla?
- Har du videre brukt ACL Manager til å diagnoser og rette opp vanlige feil etter migrering/oppdatering?

Dersom svaret er ja på begge, og du fortsatt sliter: http://forum.joomla.org/viewtopic.php?f=435&p=3225800
Rune Rasmussen - https://syntaxerror.no/
Norske nettløsninger og integrasjoner, brukerstøtte og vedlikehold m.m. for betalende kunder.

Norske oversettelser -> viewtopic.php?f=210&t=1006497

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30819
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Feil ved aktivering av versjonskontroll i Joomla 3.4

Post by Per Yngve Berg » Sun Mar 15, 2015 8:59 am

Code: Select all

 `ucm_type_id` =
Det mangler en verdi her.

geirl
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Mar 06, 2015 11:56 am

Re: Feil ved aktivering av versjonskontroll i Joomla 3.4

Post by geirl » Sun Mar 15, 2015 9:46 am

Takk for svar, begge to. Jeg har installert og kjørt ACL Manager, men selv om jeg rettet om noen feil her, løste det ikke problemet. Det eksisterer fortsatt. Nettsidene ble installert på Joomla v. 3.3.6 og eneste oppgradering er til v. 3.4. Her er rapport fra FPA:
Actions Taken To Resolve by Forum Post Assistant (v1.2.4) 15th March 2015 wrote:Sjekket databasetabeller i Joomla admin, installert og diagnostisert via ACL Manager. Her var det noen feil, men de er rettet opp og feilen er fortsatt der.
Forum Post Assistant (v1.2.4) : 15th March 2015 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.4.0-Stable (Ember) 24-February-2015
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (644) | Owner: gravstel (uid: 1/gid: 1) | Group: gravstel (gid: 1) | Valid For: 3.4
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 1 | .htaccess/web.config: Yes | GZip: 0 | Cache: 0 | FTP Layer: 0 | SSL: 0 | Error Reporting: default | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 2.6.18-408.8.2.el5.lve0.8.62 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: /home/gravstel/public_html | System TMP Writable: Yes

PHP Configuration :: Version: 5.4.34 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 24567 | Log Errors To: error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 100M | Max. Input Time: 60 | Max. Execution Time: 120 | Memory Limit: 1024M

MySQL Configuration :: Version: 5.5.41-cll-lve (Client:5.5.41) | Host: --protected-- (--protected--) | Collation: latin1_swedish_ci (Character Set: latin1) | Database Size: 5.87 MiB | #of Tables:  97
Detailed Environment :: wrote:PHP Extensions :: Core (5.4.34) | date (5.4.34) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7) | zlib (2.0) | bcmath () | bz2 () | calendar () | ctype () | curl () | dom (20031129) | hash (1.0) | filter (0.11.0) | ftp () | gd () | SPL (0.2) | iconv () | session () | json (1.2.1) | mbstring () | mcrypt () | standard (5.4.34) | mysql (1.0) | mysqli (0.1) | posix () | Reflection ($Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $) | mysqlnd (mysqlnd 5.0.10 - 20111026 - $Id: c85105d7c6f7d70d609bb4c000257868a40840ab $) | imap () | SimpleXML (0.1) | soap () | sockets () | exif (1.4 $Id: 637ebf9289b40d157fdf8edcdddeb3d907b28d9b $) | tokenizer (0.1) | xml () | xmlreader (0.1) | xmlwriter (0.1) | zip (1.11.0) | cgi-fcgi () | PDO (1.0.4dev) | pdo_sqlite (1.0.1) | timezonedb (2014.9) | pdo_mysql (1.0.2) | ionCube Loader () | Zend Guard Loader () | Zend Engine (2.4.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: No | 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) ::
Extensions Discovered :: wrote:Components :: SITE :: com_wrapper (3.0.0) | os_paypal (1.0) | os_offline (1.0) | WF_LINK_TITLE (2.4.6) | WF_STYLE_TITLE (2.4.6) | WF_STYLESELECT_TITLE (2.4.6) | WF_SOURCE_TITLE (2.4.6) | WF_FORMATSELECT_TITLE (2.4.6) | WF_PREVIEW_TITLE (2.4.6) | WF_CLIPBOARD_TITLE (2.4.6) | WF_FONTSIZESELECT_TITLE (2.4.6) | WF_CLEANUP_TITLE (2.4.6) | WF_XHTMLXTRAS_TITLE (2.4.6) | WF_CONTEXTMENU_TITLE (2.4.6) | WF_FULLSCREEN_TITLE (2.4.6) | WF_LISTS_TITLE (2.4.6) | WF_ARTICLE_TITLE (2.4.6) | WF_PRINT_TITLE (2.4.6) | WF_IMGMANAGER_TITLE (2.4.6) | WF_MEDIA_TITLE (2.4.6) | WF_CHARMAP_TITLE (2.4.6) | WF_FONTCOLOR_TITLE (2.4.6) | WF_AUTOSAVE_TITLE (2.4.6) | WF_TABLE_TITLE (2.4.6) | WF_INLINEPOPUPS_TITLE (2.4.6) | WF_IMGMANAGER_EXT_TITLE (2.0.28) | WF_NONBREAKING_TITLE (2.4.6) | WF_ANCHOR_TITLE (2.4.6) | WF_LAYER_TITLE (2.4.6) | WF_VISUALBLOCKS_TITLE (2.4.6) | WF_TEXTCASE_TITLE (2.4.6) | WF_VISUALCHARS_TITLE (2.4.6) | WF_SPELLCHECKER_TITLE (2.4.6) | WF_DIRECTIONALITY_TITLE (2.4.6) | WF_BROWSER_TITLE (2.4.6) | WF_SEARCHREPLACE_TITLE (2.4.6) | WF_MEDIAMANAGER_TITLE (2.0.14) | WF_FILEMANAGER_TITLE (2.1.8) | WF_KITCHENSINK_TITLE (2.4.6) | WF_FONTSELECT_TITLE (2.4.6) | WF_LINKS_JOOMLALINKS_TITLE (2.4.6) | K2 Links for JCE Link (2.2) | WF_POPUPS_WINDOW_TITLE (2.4.6) | WF_POPUPS_JCEMEDIABOX_TITLE (2.4.6) | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.4.6) | WF_AGGREGATOR_[youtube]_TITLE (2.4.6) | WF_AGGREGATOR_VINE_TITLE (2.4.6) | WF_AGGREGATOR_VIMEO_TITLE (2.4.6) | WF_LINK_SEARCH_TITLE (2.4.6) | WF_FILESYSTEM_JOOMLA_TITLE (2.4.6) | com_mailto (3.0.0) |
Components :: ADMIN :: com_modules (3.0.0) | Akeeba (4.1.2) | com_messages (3.0.0) | com_templates (3.0.0) | com_login (3.0.0) | com_checkin (3.0.0) | com_contenthistory (3.2.0) | OS Membership (1.7.0) | com_content (3.0.0) | com_menus (3.0.0) | com_languages (3.0.0) | com_banners (3.0.0) | com_ajax (3.2.0) | com_cpanel (3.0.0) | com_admin (3.0.0) | COM_ACLMANAGER (2.4.6) | com_media (3.0.0) | com_categories (3.0.0) | com_jaextmanager (2.5.3) | com_jaextmanager (2.6.0) | JCE (2.4.6) | Unknown (-) | com_finder (3.0.0) | com_installer (3.0.0) | com_osmap (3.0.0) | com_search (3.0.0) | com_users (3.0.0) | com_weblinks (3.0.0) | com_config (3.0.0) | com_newsfeeds (3.0.0) | com_tags (3.1.0) | com_redirect (3.0.0) | com_joomlaupdate (3.0.0) | com_postinstall (3.2.0) | com_plugins (3.0.0) | com_cache (3.0.0) |

Modules :: SITE :: mod_footer (3.0.0) | mod_wrapper (3.0.0) | mod_menu (3.0.0) | mod_related_items (3.0.0) | mod_tags_popular (3.1.0) | mod_users_latest (3.0.0) | mod_articles_news (3.0.0) | Membership Plans (1.5.1) | mod_breadcrumbs (3.0.0) | mod_languages (3.0.0) | mod_finder (3.0.0) | mod_articles_latest (3.0.0) | mod_tags_similar (3.1.0) | mod_login (3.0.0) | mod_search (3.0.0) | mod_weblinks (3.0.0) | mod_articles_popular (3.0.0) | ARI Image Slider (2.1.12) | ARI Image Slider (2.1.12) | mod_articles_category (3.0.0) | mod_banners (3.0.0) | mod_feed (3.0.0) | mod_custom (3.0.0) | mod_articles_categories (3.0.0) | mod_random_image (3.0.0) | mod_articles_archive (3.0.0) | mod_syndicate (3.0.0) | mod_stats (3.0.0) | mod_whosonline (3.0.0) | JA Slideshow (2.7.4) |
Modules :: ADMIN :: mod_menu (3.0.0) | mod_multilangstatus (3.0.0) | mod_status (3.0.0) | mod_quickicon (3.0.0) | mod_version (3.0.0) | mod_logged (3.0.0) | mod_toolbar (3.0.0) | mod_login (3.0.0) | mod_title (3.0.0) | mod_popular (3.0.0) | mod_submenu (3.0.0) | mod_stats_admin (3.0.0) | mod_feed (3.0.0) | mod_custom (3.0.0) | mod_latest (3.0.0) |

Plugins :: SITE :: plg_editors_jce (2.4.6) | plg_editors_tinymce (4.1.7) | plg_editors_codemirror (4.12) | plg_authentication_ldap (3.0.0) | plg_authentication_joomla (3.0.0) | plg_authentication_gmail (3.0.0) | plg_authentication_cookie (3.0.0) | plg_installer_akeebabackup (1.0) | plg_quickicon_extensionupdate (3.0.0) | plg_quickicon_akeebabackup (1.0) | plg_quickicon_joomlaupdate (3.0.0) | plg_quickicon_jcefilebrowser (2.4.6) | plg_twofactorauth_yubikey (3.2.0) | plg_twofactorauth_totp (3.2.0) | OS Membership - Acymailing plu (1.0) | OS Membership - Invoice Genera (1.5.1) | OS Membership - Urls Restricti (1.0) | OS Membership - Group Membersh (1.0) | OS Membership - Membership ID (1.1.1) | OS Membership - K2 Items restr (1.0) | OS Membership - Simlizing Rene (1.7.0) | OS Membership - Articles restr (1.0) | OS Membership - Userprofile pl (1.0) | Membership Pro - Mailchimp plu (1.0) | OS Membership - Easysocial plu (1.0) | OS Membership - Account creati (1.6.5) | OS Membership - Docman plugin (1.0) | OS Membership - Joomsocial plu (1.0) | OS Membership - CB plugin (1.0) | OS Membership - Joomla Groups (1.0) | OS Membership User (1.0.0) | plg_captcha_recaptcha (3.4.0) | plg_system_logout (3.0.0) | OS Membership Articles Restric (1.0.0) | OS Membership Update Subscribe (1.0.0) | T3 Framework (2.4.5) | OS Membership K2 items Restric (1.0.0) | System OS Membership Cleaner (1.6.5) | PLG_SRP_TITLE (4.1.2) | plg_system_highlight (3.0.0) | plg_system_p3p (3.0.0) | OS Membership Registration Red (1.5.1) | plg_system_languagecode (3.0.0) | OS Membership Reminder (1.0.0) | PLG_SYSTEM_BACKUPONUPDATE_TITL (3.7) | OS Membership URLs Restriction (1.0.0) | plg_system_log (3.0.0) | plg_system_sef (3.0.0) | plg_system_languagefilter (3.0.0) | plg_system_redirect (3.0.0) | plg_system_remember (3.0.0) | plg_system_cache (3.0.0) | PLG_SYSTEM_AKEEBAUPDATECHECK_T (1.1) | plg_system_ossystem (1.0.5) | System - ACL Manager (2.4.6) | plg_system_debug (3.0.0) | plg_search_weblinks (3.0.0) | plg_search_tags (3.0.0) | plg_search_newsfeeds (3.0.0) | plg_search_content (3.0.0) | plg_search_categories (3.0.0) | plg_search_contacts (3.0.0) | plg_content_emailcloak (3.0.0) | plg_content_vote (3.0.0) | plg_content_pagebreak (3.0.0) | plg_content_pagenavigation (3.0.0) | Membership Plans content plugi (1.5.0) | plg_content_joomla (3.0.0) | plg_content_loadmodule (3.0.0) | Content - Membership Pro Conte (1.5.0) | plg_content_finder (3.0.0) | plg_extension_joomla (3.0.0) | plg_finder_weblinks (3.0.0) | plg_finder_tags (3.0.0) | plg_finder_newsfeeds (3.0.0) | plg_finder_content (3.0.0) | plg_finder_categories (3.0.0) | plg_finder_contacts (3.0.0) | Xmap - SobiPro Plugin (2.0.2) | Xmap - Content Plugin (3.0.0) | XMAP_PLUGIN_K2 (1.3) | Xmap - Mosets Tree Plugin (2.0.2) | Xmap - Kunena Plugin (3.0.0) | Xmap - WebLinks Plugin (2.0.1) | Xmap - Virtuemart Plugin (2.0.3) | plg_editors-xtd_readmore (3.0.0) | plg_editors-xtd_pagebreak (3.0.0) | plg_editors-xtd_article (3.0.0) | plg_editors-xtd_image (3.0.0) | plg_user_profile (3.0.0) | plg_user_joomla (3.0.0) | plg_user_contactcreator (3.0.0) |
Templates Discovered :: wrote:Templates :: SITE :: beez3 (3.1.0) | t3_bs3_blank (2.1.8) | t3_blank (2.1.8) | protostar (1.0) |
Templates :: ADMIN :: isis (1.0) | hathor (3.0.0) |

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30819
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Feil ved aktivering av versjonskontroll i Joomla 3.4

Post by Per Yngve Berg » Sun Mar 15, 2015 12:43 pm

Feltet ucm_type_id finnes også i tabellen #__ucm_base. Denne tabellen er tom hos meg.

geirl
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Mar 06, 2015 11:56 am

Re: Feil ved aktivering av versjonskontroll i Joomla 3.4

Post by geirl » Mon Mar 16, 2015 9:13 am

Per Yngve Berg wrote:Feltet ucm_type_id finnes også i tabellen #__ucm_base. Denne tabellen er tom hos meg.
Jeg har tre tabeller #_ucm_base, #_ucm_content og ucm_history. Ingen av feltene disse tabellene har verdier. De er tomme... Har også testet med en fersk versjon av 3.3.6 og også oppgradert den til 3.4. Verdiene er tomme helt til man lagrer noe. Da begynner #ucm_history å fylles opp.
Men på denne versjonen er det altså noe feil som gjør at versjonskontrollen ikke fungerer. Ingen ting blir lagret i #ucm_history.

Jeg har søkt globalt på forumet og kommet over denne artikkelen: http://forum.joomla.org/viewtopic.php?f ... stem+error men den gir heller ikke noe svar...


Locked

Return to “Generelt”