Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Login

Or Register
Accueil / forum / Public Forum / Main Forum / [RESOLVED] mysql error at installation

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

×

Notice

The forum is in read only mode.

  1. forum
  3. Public Forum
  5. Main Forum
  7. [RESOLVED] mysql error at installation
× OLD Forum post could be checked here : forum.joomprod.com

[RESOLVED] mysql error at installation

More
10 years 9 months ago - 10 years 9 months ago #17820 by gesualda
[RESOLVED] mysql error at installation was created by gesualda
Test local serveur :
wampserveur
apache 2.4.18
php : 5.6.17
mysql 5.7.10

Hello,
A problem with the installation

Alerte
Toutes les parties d'un index PRIMARY KEY doivent être NOT NULL; Si vous avez besoin d'un NULL dans l'index, utilisez un index UNIQUE SQL=CREATE TABLE IF NOT EXISTS `zural_adsmanager_tags` ( type varchar(50) default NULL, value varchar(255) default NULL, PRIMARY KEY (`type`,`value`) ) DEFAULT CHARACTER SET utf8;

APACHE 2.4.18 - PHP 5.5.27/5.6.18/7.0.3 - MYSQL 5.7.10 - PHPMyadmin 4.5.3.1
CMS Joomla : 2.5 - 3.4.8 - Joomla test 3.5.6
Last edit: 10 years 9 months ago by loic.
The following user(s) said Thank You: adarr
More
10 years 9 months ago #17823 by gesualda
Replied by gesualda on topic mysql error at installation
Hello,
I changed this way in the SQL file.
Now it works.

If you could take it into account for the next versions.
Thank you

CREATE TABLE IF NOT EXISTS `#__adsmanager_tags` (
	type varchar(50) NOT NULL,
	value varchar(255) NOT NULL,
	PRIMARY KEY  (`type`,`value`)
) DEFAULT CHARACTER SET utf8;
APACHE 2.4.18 - PHP 5.5.27/5.6.18/7.0.3 - MYSQL 5.7.10 - PHPMyadmin 4.5.3.1
CMS Joomla : 2.5 - 3.4.8 - Joomla test 3.5.6
The following user(s) said Thank You: adarr
More
10 years 9 months ago #17830 by loic
Replied by loic on topic mysql error at installation
Hello,

I've made the modification.
Thanks for the information.

Best regards.
The following user(s) said Thank You: adarr
Moderators: perry
  1. forum
  3. Public Forum
  5. Main Forum
  7. [RESOLVED] mysql error at installation
Time to create page: 0.050 seconds
Powered by Kunena Forum