[GET] Nextpost Instagram Auto Post and Scheduler - Nextpost Instagram V4.0.4 + Modules v4.0

[papapanda]

(06-17-2018 07:31 PM)goorda Wrote:  Auto follow:

Auto like:

Auto repost:

Works here.
Want me to set it up for you? I'll recheck your setup and make it work for a small fee.

my fault,
its work now,
i forgot to create cron job in my hosting,
now all module is work

thanks for your attention goorda, rep sent

[BlueChip]

Awesome! This works :) Thanks so so much @goorda You are the best! +5 reps added.

[ronakx33]

(06-15-2018 02:36 AM)lylep Wrote:  

(06-14-2018 11:25 PM)goorda Wrote:  Hi,

There is an issue with the script, specifically the database structure.

When trying to make a post this is the error that I receive in the interface for new post:
Oops! An error occured. Please try again later!

the php error log:

Code:

2018/06/14 15:23:29 [error] 7168#0: *6867 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054   Unknown column 'first_comment' in 'field list' in /var/www/instapost..../htdocs/app/vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/QueryBuilderHandler.php:152

Stack trace:

#0 /var/www/instapost.../htdocs/app/vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/QueryBuilderHandler.php(152): PDOStatement->execute()

After further debugging I found the reason.
The database structure is for OLD version of the nextposter. You're using some part of the code that is old and some part of the code that is new. This does NOT work!

This code is what causes the error because it is trying to insert data into 4 columns first_comment, location, media_ids and remove_media into table np_posts which do not exist. Adding these 4 columns fixes the error and posting works.

Code:

55 Query     INSERT INTO `np_posts` (`id`,`status`,`user_id`,`type`,`caption`,`first_comment`,`location`,`media_ids`​,`remove_media`,`account_id`,`is_scheduled`,`create_date`,`schedule_date`,`publi​sh_date`,`is_hidden`,`data`) VALUES (NULL,'publishing','1','timeline','','','','2',0,'1',0,'2018-06-14 13:54:50','2018-06-14 13:54:50','2018-06-14 13:54:50',0,'{}')

To solve this manually add the columns with phpmyadmin, sqlscript or some GUI tool and the script will work.
Enjoy.

Thank you for sharing (little broken) script. Hopefully this will now solve all the problems, if not report and we will debug it further.

Nice fix it works reps added

Can you please help me solving this problem? I am having same problem as yours but I don't know anything about phpadmin. So can you please help me solving this problem? :(

[drawdeortsaip]

(06-15-2018 07:53 AM)scriptscraft Wrote:  Yes this is db from prev. version of NextPost, manually upgraded. And we all suffer :( so ...

Here is fix:
[VT]

Code:

https://www.virustotal.com/ru/file/436361c10bde273f182b82ff2b5ea73c4b60dc0cbb104817802d46fa9643a4b3/analysis/1529011425/

[Link]

Code:

https://www.mirrorcreator.com/files/07EMHZ5U/Nextpost_Instagram_V4.0.4-SQL-FIX1.zip_links

I used this fix and installation worked. Also the modules got installed and activated. However, I can't seem to add an instagram account. I am sure the username and password is correct, however, it is giving an error that the username and/or password is incorrect.

Any thoughts? Thank you in advance!

[C0D3R]

Wow thanks, really awesome!

[Farid27]

hello ! sorry for my question but how it install ? In my PC or my phone ? where do I decompress all the files ? sorry if it's a ridicule question but I am newbie so thanks a lot gor help.

[member]

Please update Nextpost Instagram And Modules

[xacall]

"Sorry, we couldn't add this account at the moment. Please try again some time later."

[wayne_rooney]

The modules like, follow seems to be working. But i can't post anything.

it says Oops! An error occured. Please try again later!

Quote:PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'first_comment' in 'field list' in - /public_html/app/vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/QueryBuilderHandler.php:152"

i have used the fixed version.

[nichelist]

Yup. I have the same problem too. The modules (auto follow, like etc) are working perfectly but the normal posting to instagram accounts is not.

Please somebody help!

Thank you in advance.

Nichelist

(07-03-2018 06:08 PM)wayne_rooney Wrote:  The modules like, follow seems to be working. But i can't post anything.

it says Oops! An error occured. Please try again later!

Quote:PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'first_comment' in 'field list' in - /public_html/app/vendor/usmanhalalit/pixie/src/Pixie/QueryBuilder/QueryBuilderHandler.php:152"

i have used the fixed version.