I have the Version 3.3.0 PRO of amember and currently I have install it on localhost. When i am installing Amember pro on localhost its showing mysql errors like "you have an error in your sql syntex ,cheak the manual that corresponds to your Mysql Server Version ..... " . I tried to resolve these errors from my side and i changed in amember.sql file. i changed in four tables 1.access_log 2. aff_clicks 3. cron_run 4. error_log I changed "time timestamp(14) NOT NULL" to "time datetime NOT NULL" only in all four tables.Then i started installation process again then Amember pro installed successfully. But when i am going in member login it is showing error: ( ! ) Deprecated: Assigning the return value of new by reference is deprecated in D:\wamp\www\studentconnectionsamember\member.php on line 118 ( ! ) Deprecated: Assigning the return value of new by reference is deprecated in D:\wamp\www\studentconnectionsamember\member.php on line 397 And also if i open admin panel and adding a product then it is showing some warrning which are in attechement file name adminError.jpg. And it is showing "( ! ) Deprecated:" error in every page of amember. How can i resolve these issues please help me or provide any other alternate solution anyhow. looking forward for an early response. And, if also I install it directly on the website to which I owe the amember pro - do it work properly, please help and advice as soon as possible, it is really urgent. Please urgent guidance required, any help will be appreciated.
Your modifications in amember.sql file were correct. In order to fix deprecated errors, edit php.ini and change error_reporting setting to : error_reporting = E_ALL ^ E_DEPRECATED Yes it will work without any modifications because most hosting servers already have error_reporting set to above value.
And to be clear, this php.ini setting should be modified regardless of aMember. A production server should never be set to display deprecation or warning errors.