I can't install Adsmanager

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
conteblu
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Mar 24, 2013 9:15 am

I can't install Adsmanager

Post by conteblu » Sun Mar 24, 2013 9:23 am

Hello everyone, I have a problem with AdsManager. I can't install it. I followed all the instructions in the file, I unzipped it but nothing to do. I also looked in the forum but there isn't a solution.
I tried changing the local server from Xampp to Wampserver but to no avail. I've tried using Joomla 2.5 but it doesn't work too.
This is the error:

1067 Invalid default value for 'special' SQL=CREATE TABLE IF NOT EXISTS `u16xo_adsmanager_config` ( `id` int(10) unsigned NOT NULL auto_increment, `version` text NOT NULL, `ads_per_page` int(10) unsigned NOT NULL default '20', `max_image_size` int(10) unsigned NOT NULL default '102400', `max_width` int(4) NOT NULL default '450', `max_height` int(4) NOT NULL default '300', `max_width_t` int(4) NOT NULL default '150', `max_height_t` int(4) NOT NULL default '100', `root_allowed` tinyint(4) NOT NULL default '1', `nb_images` int(4) NOT NULL default '2', `show_contact` tinyint(4) NOT NULL default '1', `send_email_on_new` tinyint(4) NOT NULL default '1', `send_email_on_update` tinyint(4) NOT NULL default '1', `auto_publish` tinyint(4) NOT NULL default '1', `tag` text NOT NULL, `fronttext` text NOT NULL, `comprofiler` tinyint(4) NOT NULL default '0', `email_display` tinyint(4) NOT NULL default '0', `rules_text` text NOT NULL, `display_expand` tinyint(4) NOT NULL default '1', `display_last` tinyint(4) NOT NULL default '2', `display_fullname` tinyint(4) NOT NULL default '2', `expiration` tinyint(1) NOT NULL default '1', `ad_duration` int(4) NOT NULL default '30', `recall` tinyint(1) NOT NULL default '1', `recall_time` int(4) NOT NULL default '7', `recall_text` text NOT NULL, `image_display` varchar(50) NOT NULL default 'default', `cat_max_width` int(4) NOT NULL default '150', `cat_max_height` int(4) NOT NULL default '150', `cat_max_width_t` int(4) NOT NULL default '30', `cat_max_height_t` int(4) NOT NULL default '30', `submission_type` int(4) NOT NULL default '30', `nb_ads_by_user` int(4) NOT NULL default '-1', `allow_attachement` tinyint(1) NOT NULL default '0', `allow_contact_by_pms` tinyint(1) NOT NULL default '0', `show_rss` tinyint(1) NOT NULL default '0', `nbcats` int(4) NOT NULL default '1', `show_new` tinyint(1) NOT NULL default '1', `nbdays_new` int(10) NOT NULL default '5', `show_hot` tinyint(1) NOT NULL default '1', `nbhits` int(10) NOT NULL default '100', `bannedwords` TEXT DEFAULT NULL, `replaceword` TEXT DEFAULT NULL, `after_expiration` TEXT DEFAULT NULL, `archive_catid` int(10) NOT NULL default '1', `metadata_description` text, `metadata_keywords` text, `autocomplete` tinyint(1) default '0', `jquery` tinyint(1) default '1', `jqueryui` tinyint(1) default '1', `disable_post` tinyint(1) NOT NULL default '0', `nb_last_cols` int(10) NOT NULL default '3', `nb_last_rows` int(10) NOT NULL default '1', `display_general_menu` tinyint(1) NOT NULL default '1', `display_list_sort` tinyint(1) NOT NULL default '1', `display_list_search` tinyint(1) NOT NULL default '1', `display_inner_pathway` tinyint(1) NOT NULL default '1', `display_front` tinyint(1) NOT NULL default '1', `send_email_on_new_to_user` tinyint(4) NOT NULL default '1', `send_email_on_update_to_user` tinyint(4) NOT NULL default '0', `send_email_on_validation_to_user` tinyint(4) NOT NULL default '1', `new_text` text NOT NULL, `update_text` text NOT NULL, `admin_new_text` text NOT NULL, `admin_update_text` text NOT NULL, `waiting_validation_text` text NOT NULL, `validation_text` text NOT NULL, `expiration_text` text NOT NULL, `new_subject` text NOT NULL, `update_subject` text NOT NULL, `admin_new_subject` text NOT NULL, `admin_update_subject` text NOT NULL, `waiting_validation_subject` text NOT NULL, `validation_subject` text NOT NULL, `expiration_subject` text NOT NULL, `recall_subject` text NOT NULL, `params` text DEFAULT NULL, `special` text DEFAULT NULL PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8;

If you know another good extension to create a classifieds site with registration for the public let me know.
Thanks for any help!

 
User avatar
andypooz
Joomla! Guru
Joomla! Guru
Posts: 708
Joined: Sat Dec 30, 2006 3:03 pm
Location: London, UK
Contact:

Re: I can't install Adsmanager

Post by andypooz » Sun Mar 24, 2013 9:53 am

I think there's an error in the sql. If you change the final bit of the sql from

Code: Select all

 `special` text DEFAULT NULL PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8; 
to

Code: Select all

 `special` text DEFAULT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8;
ie. a missing comma is making SQL think all the primary key stuff is about the default value of the 'special' field. Track down the script where this sql is (probably install.sql or install.php) and add the comma. Rezip and re-install and *hopefully* it'll work.

If it does fix this, make sure you let the developers know of the issue so that they can fix it. This is the kind of error that should cause an install fail every time.

Andy
Andy Hickey
Bespoke Joomla Extension Developer
http://www.netamity.com

conteblu
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sun Mar 24, 2013 9:15 am

Re: I can't install Adsmanager

Post by conteblu » Sun Mar 24, 2013 4:01 pm

Ok! Thank you! The installation is successful after I changed the file install.sql as you suggested.
Now, however, while the backend is completely normal when I open the main page of AdsManager in the frontend there are some strange warnings:

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 77

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 170

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 175

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 77

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 170

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 175

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 77

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 170

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 175

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 77

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 170

Strict Standards: Only variables should be assigned by reference in C:\xampp\htdocs\stregagatta\components\com_adsmanager\lib\route.php on line 175


For clarity I put a screenshot in attachment...
Annunci.jpg
Now what can I do?
You do not have the required permissions to view the files attached to this post.

User avatar
andypooz
Joomla! Guru
Joomla! Guru
Posts: 708
Joined: Sat Dec 30, 2006 3:03 pm
Location: London, UK
Contact:

Re: I can't install Adsmanager

Post by andypooz » Sun Mar 24, 2013 6:52 pm

Go to your global configuration and turn your error reporting to 'none' and debug to 'no'. These are strict standards warnings and aren't errors per se. You can live with them (as long as you don't have them being displayed).

Please don't forget to inform the extension developers of this issue. If it is their latest version they'll want to know because others will have the same problem.
Andy Hickey
Bespoke Joomla Extension Developer
http://www.netamity.com

 

Locked

Return to “Extensions for Joomla! 3.x”