Can not import with MYSQL import

[Anthony]

Hi there,

Since I upgraded to the latest script I am unable to connect to my sq db, this is the error

• Your form has a few errors, please fix them and try again!
  CDbConnection failed to open the DB connection.

But I have not made any errors in the information

 

[twisted1919]

This should help https://forum.mailwizz.com/threads/import-subscribers-from-remote-mysql.95/

 

[Anthony]

Thank you, It was working prior to the MailWhizz update, so can it still be something to my server as pose to the script?

 

[twisted1919]

Well, i haven't changed the mysql import code at all, so if something changed, it did in Yii Framework where things are a bit trickier to handle.
I'd say to look into your mysql logs and see the reason and fix it, like shown in the above link.

 

[Anthony]

Thank you, Ill let you know how I get on.

 

[Anthony]

Hi Twisted, so weird, I left the "ignore columns" box blank and it worked?

 

[twisted1919]

Could you take a screenshot from your mysql import screen when it fails and post it here, of course, hide sensitive data.

 

[Anthony]

apologies, it was probably a temporary problem with my server as now it is working with ignore columns, I sound like such a noob, thank you for responding to my enquiry so fast.