Weblinks 3.4 - Error installing component

This forum is for general questions about extensions for Joomla! 3.x.

Moderators: pe7er, 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.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
kgendler
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Sep 16, 2008 11:12 pm

Weblinks 3.4 - Error installing component

Post by kgendler » Mon Mar 16, 2015 10:30 pm

I am migrating a site from 2.5.28 to 3.4. While attempting to install http://extensions.joomla.org/extensions ... s/weblinks I received the following message:

Code: Select all

Warning
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 'delimiter ';;' create procedure weblinks_schema_change() begin /* delete colum' at line 1 SQL=delimiter ';;' create procedure weblinks_schema_change() begin /* delete columns if they exist */ if exists(SELECT * FROM information_schema.columns WHERE table_name = '#__weblinks' AND column_name = 'sid') THEN ALTER TABLE `jml_weblinks` DROP COLUMN `sid`;
Here are some configuration details:
  • Database schema version (in #__schemas): 3.4.0-2015-01-21.
  • Update version (in #__extensions): 3.4.0.
  • Database driver: mysqli.
  • Database Version: 5.5.41-37.0-log
  • Database Collation: utf8_general_ci
  • PHP Version: 5.4.34
  • Web Server: Apache
  • WebServer to PHP Interface: cgi-fcgi
  • Joomla! Version: Joomla! 3.4.0 Stable [ Ember ] 24-February-2015 23:00 GMT
  • Joomla! Platform Version: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
H E L P ! :eek:
Problem Description :: Forum Post Assistant (v1.2.4) : 16th March 2015 wrote:Weblinks 3.4 - Error installing component
Log/Error Message :: Forum Post Assistant (v1.2.4) : 16th March 2015 wrote:Warning 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 'delimiter ';;' create procedure weblinks_schema_change() begin /* delete colum' at line 1 SQL=delimiter ';;' create procedure weblinks_schema_change() begin /* delete columns if they exist */ if exists(SELECT * FROM information_schema.columns WHERE table_name = '#__weblinks' AND column_name = 'sid') THEN ALTER TABLE `jml_weblinks` DROP COLUMN `sid`;
Actions Taken To Resolve by Forum Post Assistant (v1.2.4) 16th March 2015 wrote:I am migrating a site from 2.5.28 to 3.4. While attempting to install http://extensions.joomla.org/extensions ... s/weblinks I received the error message.
Forum Post Assistant (v1.2.4) : 16th 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 | Read-Only (444) | Owner: marijua9 (uid: 1/gid: 1) | Group: marijua9 (gid: 1) | Valid For: 3.4
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 1 | .htaccess/web.config: Yes | GZip: 1 | Cache: 0 | FTP Layer: 0 | SSL: 2 | Error Reporting: maximum | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 3.12.35.1418868052 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: /home5/marijua9/public_html | System TMP Writable: Yes

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

MySQL Configuration :: Version: 5.5.41-37.0-log (Client:5.5.41-37.0) | Host: --protected-- (--protected--) | Collation: utf8_general_ci (Character Set: utf8) | Database Size: 71.44 MiB | #of Tables:  120
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 () | dba () | dom (20031129) | enchant (1.1.0) | hash (1.0) | fileinfo (1.0.5) | filter (0.11.0) | ftp () | gd () | gettext () | gmp () | SPL (0.2) | iconv () | session () | intl (1.1.0) | json (1.2.1) | ldap () | mbstring () | mcrypt () | mysql (1.0) | mysqli (0.1) | odbc (1.0) | pcntl () | standard (5.4.34) | PDO (1.0.4dev) | pdo_dblib (1.0.1) | pdo_mysql (1.0.2) | PDO_ODBC (1.0.1) | pdo_pgsql (1.0.2) | pdo_sqlite (1.0.1) | pgsql () | Phar (2.0.1) | posix () | pspell () | readline (5.4.34) | recode () | Reflection ($Id: f6367cdb4e3f392af4a6d441a6641de87c2e50c4 $) | imap () | shmop () | SimpleXML (0.1) | soap () | sockets () | exif (1.4 $Id: 637ebf9289b40d157fdf8edcdddeb3d907b28d9b $) | sysvmsg () | sysvsem () | sysvshm () | tidy (2.0) | tokenizer (0.1) | wddx () | xml () | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.11.0) | cgi-fcgi () | http (1.7.6) | imagick (3.1.2) | magickwand (1.0.9) | mailparse (2.1.6) | uploadprogress (1.0.3.1) | mhash () | ionCube Loader () | Zend Engine (2.4.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) ::
Extensions Discovered :: wrote:Components :: SITE :: com_mailto (3.0.0) | WF_ANCHOR_TITLE (2.4.6) | WF_VISUALBLOCKS_TITLE (2.4.6) | WF_EMOTIONS_TITLE (2.0.3) | WF_IFRAME_TITLE (2.1.1) | WF_PRINT_TITLE (2.4.6) | WF_FONTSIZESELECT_TITLE (2.4.6) | WF_SOURCE_TITLE (2.4.6) | WF_FILEMANAGER_TITLE (2.1.8) | WF_CAPTION_TITLE (2.1.7) | WF_LINK_TITLE (2.4.6) | WF_LAYER_TITLE (2.4.6) | WF_AUTOSAVE_TITLE (2.4.6) | WF_FULLSCREEN_TITLE (2.4.6) | WF_VISUALCHARS_TITLE (2.4.6) | WF_ARTICLE_TITLE (2.4.6) | WF_SPELLCHECKER_TITLE (2.4.6) | WF_MEDIA_TITLE (2.4.6) | WF_FORMATSELECT_TITLE (2.4.6) | WF_INLINEPOPUPS_TITLE (2.4.6) | WF_PREVIEW_TITLE (2.4.6) | WF_TEXTCASE_TITLE (2.4.6) | WF_TEMPLATEMANAGER_TITLE (2.0.5) | WF_FONTSELECT_TITLE (2.4.6) | WF_MEDIAMANAGER_TITLE (2.0.14) | WF_STYLESELECT_TITLE (2.4.6) | WF_IMGMANAGER_EXT_TITLE (2.0.28) | WF_CLIPBOARD_TITLE (2.4.6) | WF_LISTS_TITLE (2.4.6) | WF_BROWSER_TITLE (2.4.6) | WF_DIRECTIONALITY_TITLE (2.4.6) | WF_CONTEXTMENU_TITLE (2.4.6) | WF_STYLE_TITLE (2.4.6) | WF_SEARCHREPLACE_TITLE (2.4.6) | WF_FONTCOLOR_TITLE (2.4.6) | WF_CHARMAP_TITLE (2.4.6) | WF_IMGMANAGER_TITLE (2.4.6) | WF_CLEANUP_TITLE (2.4.6) | WF_FULLPAGE_TITLE (2.0.3) | WF_XHTMLXTRAS_TITLE (2.4.6) | WF_NONBREAKING_TITLE (2.4.6) | WF_TABLE_TITLE (2.4.6) | WF_KITCHENSINK_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_FILESYSTEM_JOOMLA_TITLE (2.4.6) | WF_LINK_SEARCH_TITLE (2.4.6) | WF_MEDIAPLAYER_JCEPLAYER_TITLE (2.4.6) | WF_AGGREGATOR_VIMEO_TITLE (2.4.6) | WF_AGGREGATOR_VINE_TITLE (2.4.6) | WF_AGGREGATOR_[youtube]_TITLE (2.4.6) | com_wrapper (3.0.0) |
Components :: ADMIN :: com_categories (3.0.0) | Akeeba (4.1.2) | com_weblinks (2.5.0) | Remository (3.55.04J2) | com_users (3.0.0) | com_modules (3.0.0) | com_messages (3.0.0) | com_admin (3.0.0) | com_tags (3.1.0) | com_ajax (3.2.0) | com_config (3.0.0) | com_media (3.0.0) | com_newsfeeds (3.0.0) | Unknown (-) | JCE (2.4.6) | com_redirect (3.0.0) | com_content (3.0.0) | com_joomlaupdate (3.0.0) | com_finder (3.0.0) | com_cache (3.0.0) | com_banners (3.0.0) | com_plugins (3.0.0) | com_search (3.0.0) | com_postinstall (3.2.0) | com_cpanel (3.0.0) | com_menus (3.0.0) | com_languages (3.0.0) | com_contenthistory (3.2.0) | JMap (3.2) | com_rsform (1.50.11) | com_login (3.0.0) | com_checkin (3.0.0) | com_installer (3.0.0) | com_templates (3.0.0) |

Modules :: SITE :: mod_tags_similar (3.1.0) | Simple MP3 Player 1.7.1 (1.7.1) | mod_weblinks (3.4.0-rc) | mod_languages (3.0.0) | mod_banners (3.0.0) | mod_articles_category (3.0.0) | RSForm! Pro Module (1.4.0) | mod_custom (3.0.0) | mod_breadcrumbs (3.0.0) | mod_login (3.0.0) | mod_wrapper (3.0.0) | mod_stats (3.0.0) | mod_articles_categories (3.0.0) | mod_users_latest (3.0.0) | RSForm! Pro Module Frontend Li (1.4.0) | RSForm! Pro Feedback Module (1.4.0) | mod_articles_popular (3.0.0) | mod_finder (3.0.0) | mod_syndicate (3.0.0) | mod_menu (3.0.0) | mod_articles_news (3.0.0) | mod_articles_archive (3.0.0) | mod_random_image (3.0.0) | mod_tags_popular (3.1.0) | mod_whosonline (3.0.0) | mod_articles_latest (3.0.0) | mod_search (3.0.0) | JSitemap module (3.2) | mod_footer (3.0.0) | mod_feed (3.0.0) | mod_related_items (3.0.0) |
Modules :: ADMIN :: mod_submenu (3.0.0) | mod_status (3.0.0) | mod_custom (3.0.0) | mod_login (3.0.0) | mod_title (3.0.0) | Google Analytics Dashboard (2.7) | mod_popular (3.0.0) | JSitemap Quickicons (3.2) | mod_version (3.0.0) | mod_menu (3.0.0) | mod_logged (3.0.0) | mod_toolbar (3.0.0) | mod_quickicon (3.0.0) | mod_feed (3.0.0) | mod_multilangstatus (3.0.0) | mod_latest (3.0.0) | mod_stats_admin (3.0.0) |

Plugins :: SITE :: Content - RSForm! Pro (1.4.0) | plg_content_pagenavigation (3.0.0) | Content - InstantPaypal (1.1) | plg_content_geshi (2.5.0) | plg_content_loadmodule (3.0.0) | plg_content_emailcloak (3.0.0) | plg_content_finder (3.0.0) | plg_content_pagebreak (3.0.0) | plg_content_joomla (3.0.0) | plg_content_vote (3.0.0) | Content - JSitemap Pingomatic (3.2) | plg_authentication_gmail (3.0.0) | plg_authentication_ldap (3.0.0) | plg_authentication_joomla (3.0.0) | plg_authentication_cookie (3.0.0) | plg_twofactorauth_yubikey (3.2.0) | plg_twofactorauth_totp (3.2.0) | plg_captcha_recaptcha (3.4.0) | plg_installer_webinstaller (1.0.5) | plg_user_profile (3.0.0) | plg_user_contactcreator (3.0.0) | plg_user_joomla (3.0.0) | plg_finder_content (3.0.0) | plg_finder_tags (3.0.0) | plg_finder_categories (3.0.0) | plg_finder_newsfeeds (3.0.0) | plg_finder_contacts (3.0.0) | plg_finder_weblinks (3.4.0-rc) | plg_editors-xtd_readmore (3.0.0) | plg_editors-xtd_article (3.0.0) | PLG_EDITORS-XTD_SOURCERER (4.4.7FREE) | plg_editors-xtd_image (3.0.0) | plg_editors-xtd_pagebreak (3.0.0) | plg_editors_codemirror (4.12) | plg_editors_jce (2.4.6) | plg_editors_tinymce (4.1.7) | PLG_SEARCH_REMOSITORY (3.55J2) | plg_search_content (3.0.0) | plg_search_tags (3.0.0) | plg_search_categories (3.0.0) | plg_search_newsfeeds (3.0.0) | plg_search_contacts (3.0.0) | plg_search_weblinks (2.5.0) | System - RSForm! Pro Google An (1.4.0) | PLG_SYSTEM_NNFRAMEWORK (14.11.8) | plg_system_debug (3.0.0) | PLG_SYS_BYEBYEGENERATOR (1.11) | System - JSitemap utilities (3.2) | System - RSForm! Pro (1.50.10) | PLG_SYSTEM_SOURCERER (4.4.7FREE) | plg_system_languagefilter (3.0.0) | plg_system_languagecode (3.0.0) | System - RSForm! Pro Offline P (1.50.0) | plg_system_log (3.0.0) | plg_system_highlight (3.0.0) | System - RSForm! Pro reCAPTCHA (1.4.0) | plg_system_cache (3.0.0) | System - Google Analytics (4.6) | System - RSForm! Pro PDF (1.50.0) | plg_system_redirect (3.0.0) | plg_system_logout (3.0.0) | plg_system_remember (3.0.0) | System - RSForm! Pro reCAPTCHA (1.0.3) | plg_system_p3p (3.0.0) | System - RSForm! Pro Payment (1.50.10) | plg_system_sef (3.0.0) | System - RSForm! Pro MailChimp (1.50.1) | System - RSForm! Pro PayPal (1.50.0) | System - JCE MediaBox (1.1.19) | PLG_JMONITORING_AKEEBABACKUP_T (1.0) | plg_extension_joomla (3.0.0) | plg_quickicon_extensionupdate (3.0.0) | plg_quickicon_joomlaupdate (3.0.0) | plg_quickicon_jcefilebrowser (2.4.6) |
Templates Discovered :: wrote:Templates :: SITE :: atomic (2.5.0) | js_keenly (1.0.1) | protostar (1.0) | beez3 (3.1.0) | beez5 (2.5.0) | beez_20 (2.5.0) |
Templates :: ADMIN :: isis (1.0) | bluestork (2.5.0) | hathor (3.0.0) |

deleted user

Re: Weblinks 3.4 - Error installing component

Post by deleted user » Mon Mar 16, 2015 11:32 pm


kgendler
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Sep 16, 2008 11:12 pm

Re: Weblinks 3.4 - Error installing component

Post by kgendler » Sat Mar 21, 2015 7:03 pm

mbabker wrote:It's a known quirk, follow along at https://github.com/joomla-extensions/weblinks/issues/25
Thanks for that...and I see that there has been some activity. Hopefully we'll see a new build soon.

User avatar
Croc
Joomla! Apprentice
Joomla! Apprentice
Posts: 48
Joined: Mon Nov 17, 2008 10:20 pm
Location: Greece
Contact:

Re: Weblinks 3.4 - Error installing component

Post by Croc » Fri Mar 27, 2015 10:55 am

https://www.facebook.com/joomlafansgr/p ... 5522328273
WebLinks component is de-coupled from Joomla core. But if you are coming from upgrade, maybe you will face an error (SQL). The solution on this, is to uninstall the component/package "Weblinks" and install the official extension, this will solve the issue.
Weblinks - Joomla! Extension Directory
http://web-expert.gr/en - Joomla Hosting & Extensions

kgendler
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Sep 16, 2008 11:12 pm

Re: Weblinks 3.4 - Error installing component

Post by kgendler » Fri Mar 27, 2015 6:19 pm

@Croc - I'm not sure that suggestion will preserve the existing Weblinks content.

User avatar
Croc
Joomla! Apprentice
Joomla! Apprentice
Posts: 48
Joined: Mon Nov 17, 2008 10:20 pm
Location: Greece
Contact:

Re: Weblinks 3.4 - Error installing component

Post by Croc » Sun Mar 29, 2015 4:30 pm

I had the issue in Joomla 3.4, an error about SQL was displayed.
I uninstalled the WebLinks and I installed it again from http://extensions.joomla.org/extensions ... s/weblinks
http://web-expert.gr/en - Joomla Hosting & Extensions

johnwargo
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed Dec 03, 2014 1:02 pm

Re: Weblinks 3.4 - Error installing component

Post by johnwargo » Sun Apr 26, 2015 11:33 pm

what does that do to your existing weblinks? Won't uninstalling the existing plugin whack the existing db tables?

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

Re: Weblinks 3.4 - Error installing component

Post by Webdongle » Mon Apr 27, 2015 1:11 am

Yes I had links and uninstalling the component wiped them.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
Croc
Joomla! Apprentice
Joomla! Apprentice
Posts: 48
Joined: Mon Nov 17, 2008 10:20 pm
Location: Greece
Contact:

Re: Weblinks 3.4 - Error installing component

Post by Croc » Mon Apr 27, 2015 2:44 pm

If you unistall it ofcourse you will lose the data, but you can backup them via phpmyadmin
http://web-expert.gr/en - Joomla Hosting & Extensions

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

Re: Weblinks 3.4 - Error installing component

Post by Webdongle » Mon Apr 27, 2015 4:33 pm

Croc wrote:If you unistall it ofcourse you will lose the data, but you can backup them via phpmyadmin
Not all uninstalls remove the database tables. If you back up the tables then you keep the same structure ... as the structure is different then replacing the new tables(after reinstalling the Component) will cause the same problem.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
Croc
Joomla! Apprentice
Joomla! Apprentice
Posts: 48
Joined: Mon Nov 17, 2008 10:20 pm
Location: Greece
Contact:

Re: Weblinks 3.4 - Error installing component

Post by Croc » Mon Apr 27, 2015 8:31 pm

I agree, but is not difficult to find the diffrences comparing the SQL tables
http://web-expert.gr/en - Joomla Hosting & Extensions


Locked

Return to “Extensions for Joomla! 3.x”