This author's response time can be up to 1 business day.
I have tested with stripe recently,
I found this Err :
Unknown column ‘stripe_card_source’ in ‘field list’
i checked the transaction_history table and found no stripe_card_source,
Does my script damaged or, you missed it?
Sorry for the inconvenience. You are right, we missed it
Please run the following SQL into your database
ALTER TABLE `transaction_history` ADD `stripe_card_source` TEXT NOT NULL;
Thanks a lot for noticing this issue. We’ll release an update soon
Dont worry.. I have already did that after noticed its just a field err , Great work there.
Great job man
Plase check your mail. need help from you for installation..
Replied to your mail. Please check your inbox.
Hi dev, i moved the main domain to another host and restored everything as in the documentation and the front-page search and download works OK but the back-end searches do not work anymore.
I can search in the front but none of the searches work on the dashboard ?
Any ideas ? Please advise.
Could you please describe what do you mean by ‘restored everything’?
If you change your domain then you have to give a fresh install on the new domain.
Like i said, i move to another host and use the same domain.
The front-end search works but the back-end does not.
It should work. Is it possible to install it again?
I have installed again and the problem was “view_usage_log” database not being exported correctly.
I tried the same export and it looks like there is a problem and you need to check the install process.
When you first install the script it seems it creates the view_usage_log table in a different row of the table that is not exported and if you try to migrate the script will fail to work.
Please advise and fix this issue for the future!
Views are not like tables. Export tables except view and import it to your new database. Now open assets/backup_db/initial_db.sql and you will find sql for creating view in line 338-342. Copy the lines and run it to your new database. It will take care of everything.
The sql part looks like below :
ALGORITHM = UNDEFINED ... ... ...
Thanks : Al-amin
What is the use of the view_usage_log and why does the script fail without it ?
I could not export it but i manually created a table “view_usage_log” and seems to be working fine.
Still, if i missed something please advise.
Please drop the table “view_usage_log” from your database and then run the following query in your database
ALGORITHM = UNDEFINED
AS select * from usage_log where `usage_month`= MONTH ) and `usage_year`= YEAR ) ;
I removed the table and i get this an error when i run the code above:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and `usage_year`= YEAR )' at line 1
And tried to run the code from the export file yet i am super admin:
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
I am root and super admin with all privileges, why does it not work ?
Copying sql from web pages changes some special characters. So, copy from export file,as you did second time.
Never heard such permission issue for creating views with super privilege !!! May be your host block this by default. You should contact your hosting provider mentioning the issue. Seems like your new host have issues.
It is a dedicated server and in fresh install the script shows no problems and installs ok.
Only when you try to run the command manually in phpmyadmin.
That’s strange !!!
You can follow trick. Install a fresh copy in your new server using a new database. Then delete the installation folders as well as all tables except `view_usage_log` from database.
Now export your previous database without the view and import it to that new database. Now the new database have your previous data as well as view needed.
Now, go to application/config/database.php , change database name to the new one to switch working database.
If you have any confusion regarding the process, fell free to ask
Yes i created a new fresh install and imported all users and change the config file.
I’m followed your video to make a Google Maps API key to work and though i have enabled it, my api key is not working but your API key it works.
Any idea why my Google Maps API key is not working ?
Your key works, my key does not
Any ideas ?
What about your api key? Does it work?
No, same problem. I added your key anyway is used very little.
But why my key does not work ? I did everything like in your video, do i need to activate some special settings in my account ?
Please send your application link and admin login credential to email@example.com
I’ll check it soon
Please mention your issue in mail.
the php loads regular search in the back end, but it fritz for locations, group search, event search.
I get the following error when installing:
A Database Error Occurred
Unable to connect to your database server using the provided settings.
Line Number: 346
Any idea where it came from?
Actually, the first time I click submit in the install screen, the page reload with no error message. Then if I re-enter the information and submit again I get this error:
A Database Error Occurred
Error Number: 1062
Duplicate entry ‘1’ for key ‘PRIMARY’
INSERT INTO `modules` (`id`, `module_name`, `deleted`) VALUES (1, ‘page search’, ‘0’), (2, ‘page search by location’, ‘0’), (3, ‘group search’, ‘0’), (4, ‘user search’, ‘0’), (5, ‘event search’, ‘0’);
Line Number: 335
Fixed it myself. Weird install.
Hi, actually that was a file permission issue. application/install.txt was can not be deleted, that’s why the install screen came again. It was installed first time, I guess.
Could you fix the sorting please? In Event Search if you want to sort by attending 97 is before 800…
Will fix in next release
I want to switch my facebook scraper installation from kcdipen.com/fbdata
Please help me update the license key such that it works during installation !!
is my license key.
You can login now.
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Get it now and save up to $10.50