Support

Akeeba Ticket System

#17702 Alpha user points - error when reinstalling ATS

Posted in ‘Akeeba Ticket System for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Ticket System version
n/a

Latest post by dlb on Monday, 30 September 2013 23:50 CDT

user27579
ATS version: com_ats-pro-git_18fc265 

Hi Nicholas,

I was just able to install the alpha dev version of ATS, as I told you it worked fine.

I followed the manual instructions page 43 to integrate with Alpha Points.

First, installed Alpha Points and all related extensions. Then, reinstalled ATS, without reinstall.

But I got this error:

1146 Table 'dda_superar.i72yh_alpa_userpoints_rules' doesn't exist SQL=INSERT INTO `i72yh_alpa_userpoints_rules` (`rule_name`,`rule_description`,`rule_plugin`,`plugin_function`,`access`,`component`,`calltask`,`taskid`,`points`,`points2`,`percentage`,`rule_expire`,`sections`,`categories`,`content_items`,`exclude_items`,`published`,`system`,`duplicate`,`blockcopy`,`autoapproved`,`fixedpoints`,`category`,`displaymsg`,`msg`,`method`,`notification`,`emailsubject`,`emailbody`,`emailformat`,`bcc2admin`,`type_expire_date`) VALUES ('Akeeba Ticket System integration','Converts AUP points into ATS credits','com_ats','plgaup_ats_convert_points','1','','','','0','0','0','0000-00-00 00:00:00','','','','','1','0','0','0','1','0','ot','1','ATS conversion','4','0','','','0','0','0')

Also, when enabling system plugin System - ATS Reply by Email returned error:

COM_ATS_ERR_MAIL_CANNOTCONNECT : Can't open mailbox {imap.gmail.com:0/notls/imap/validate-cert}INBOX: invalid remote specification.

This error only desappeared when I disabled both Akeeba Ticket System - New post notification emails and System - Akeeba Ticket System reply by email.

Obs - Alpha points integration plugin was enabled sucessfully.

Regards!

Cc

dlb
Please use the latest dev release of ATS, that will solve the 1146 error. I think the rest of your problems may result from the bad installation. The dev release is at: https://www.akeebabackup.com/download/developer-releases/ats-dev.html.

Dale


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

user27579
Hi Dale,

It was Nicholas who told me to use this version :-)

By now I tried twice with the link you sent but error 1146 is still there...

Cc

dlb
When Nicholas and Dale disagree - follow Nicholas' instructions. :-)

I'm going to flag this for his attention.

Dale


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!