We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Issues with Google Contact Importer and CSV data importer [Solved] | Forum

esskay
esskay Feb 19 '15

Hi


I am on oxwall 1.7.2 and installed it yesterday. Everything is working fine except two issues -


1. I am trying to configure contact importer plugin. The facebook part is working fine but the google is giving following error -


400. That’s an error.

Error: redirect_uri_mismatch

Application: ****

You can email the developer of this application at: email

The redirect URI in the request: http://mysite.com/google/oauth did not match a registered redirect URI.


I have googled the issue and also browsed through the various posts in this forum and tried almost every solution given in various threads. However, I am unable to fix it. Most of the stuff which I have tried are from the very old posts.


2. CSV Data Import - At present I am on Jomsocial and looking for transfer the site to Oxwall. This is basically a test site. I am trying to import the users (few hundreds) from CSV file and getting this error -


"Unknow upload error"


I have even tried to import from a test file given somewhere in this forum with two test users but still the same error. Tried few solutions given in the forum but could not fix it.


Wanted to checkup any solution or if someone can guide me to the right direction....


Please advise....

The Forum post is edited by ross Mar 11 '15
esskay
esskay Feb 20 '15
Hello Community...

Please ignore point no. 1...I managed to fix this...

Now my only concern is with csv data import....If someone can reply to this...

Thanks....
esskay
esskay Feb 21 '15
Anyone...who can help me....?
Taissa Team
Taissa Feb 23 '15
esskay, can you please provide a solution for point no. 1, probably some community member will find it useful as well. Thanks in advance.

Concerning csv data import, just to confirm, have you seen this topic: http://www.oxwall.org/forum/topic/14565 ; ?
Have you corrected permissions for ow_pluginfiles and all folders within it?
What version of PHP do you use ?

Please, provide us with screenshot of error. 

The Forum post is edited by Taissa Feb 24 '15
esskay
esskay Feb 24 '15
Hi Taissa

Thanks for your reply...
Quote from Taissa can you please provide a solution for point no. 1, probably some community member will find it useful as well
I created another google api and ensured that the site name starts with http instead of https and the callback url is correct. This has fixed the problem for me. The old API I used for another 3rd party plugin to login with google+. Both are working fine now.
Quote from Taissa Concerning csv data import, just to confirm, have you seen this topic: http://www.oxwall.org/forum/topic/23000 ?
The above link take me to "register in arabic letter"...This has nothing to do with my issue. Can you please post the correct link....?
Quote from Taissa Have you corrected permissions for ow_pluginfiles and all folders within it?
Yes...I have ensured that the permission for the entire folder and all its contents is 777...
Quote from Taissa What version of PHP do you use ?
A am on PHP 5.5.9+dfsg-1ubuntu4.6
Quote from Taissa Please, provide us with screenshot of error.
Screenshot attached....

Please advise....Thanks in advance....




The Forum post is edited by esskay Feb 24 '15
Attachments:
  oxwall.doc (117Kb)
Taissa Team
Taissa Feb 25 '15
I apologize, I've corrected the link in my post.
We've tested the CSV loading function using test file and found no errors.
To understand what type of error encountered you need to add special code to display this error in the error.log file. Do not forget to backup website before doing any changes.
So you have to to change /ow_plugins/csv_importer/forms/csv_uploader.php file.
Find this block of code:
if ( !empty($_FILES['csv_file']['error']) )
            {

                switch ( $_FILES['csv_file']['error'] )
                {
                    case UPLOAD_ERR_INI_SIZE:
                        $this->setErrorMessage( OW::getLanguage()->text('csvimporter', 'upload_error_ini_size') );
                        break;

Find "switch" and add this line of code before it : OW::getLogger()->addEntry('csv import error: ' . $_FILES['csv_file']['error']);
In final it should looks like that:
if ( !empty($_FILES['csv_file']['error']) )
            {OW::getLogger()->addEntry('csv import error: ' . $_FILES['csv_file']['error']);

                switch ( $_FILES['csv_file']['error'] )
                {
                    case UPLOAD_ERR_INI_SIZE:
                        $this->setErrorMessage( OW::getLanguage()->text('csvimporter', 'upload_error_ini_size') );
                        break;

Then, you need to load again CSV file that causes an error. When error occurs open the error.log file, find error message and post it here.
If there are a few lines in this file then select the one that corresponds to the time of loading csv file.
Taissa Team
Taissa Feb 25 '15
Topic was moved from General Questions.
esskay
esskay Feb 26 '15
This is what is there in the access_log. There is nothing in the error_log....If this is not what you are looking at...please let me know the path of the error.log....

myip - - [26/Feb/2015:12:39:06 +0100] "POST /base/ping/index/ HTTP/1.0" 200 537 "http://www.mysite.com/csvimport/admin" "Mozilla/5.0 (Windows NT 6.1; rv:35.0) Gecko/20100101 Firefox/35.0"
myip - - [26/Feb/2015:12:39:11 +0100] "POST /base/ping/index/ HTTP/1.0" 200 537 "http://www.mysite.com/csvimport/admin" "Mozilla/5.0 (Windows NT 6.1; rv:35.0) Gecko/20100101 Firefox/35.0"
myip - - [26/Feb/2015:12:39:16 +0100] "POST /base/ping/index/ HTTP/1.0" 200 537 "http://www.mysite.com/csvimport/admin" "Mozilla/5.0 (Windows NT 6.1; rv:35.0) Gecko/20100101 Firefox/35.0"
myip - - [26/Feb/2015:12:39:22 +0100] "POST /base/ping/index/ HTTP/1.0" 200 636 "http://www.mysite.com/csvimport/admin" "Mozilla/5.0 (Windows NT 6.1; rv:35.0) Gecko/20100101 Firefox/35.0"
myip - - [26/Feb/2015:12:39:27 +0100] "POST /base/ping/index/ HTTP/1.0" 200 537 "http://www.mysite.com/csvimport/admin" "Mozilla/5.0 (Windows NT 6.1; rv:35.0) Gecko/20100101 Firefox/35.0"
esskay
esskay Feb 26 '15
This is the final code after adding the line as suggested -

      return TRUE;
        }
        else
        {
            if ( !empty($_FILES['csv_file']['error']) )
            {OW::getLogger()->addEntry('csv import error: ' . $_FILES['csv_file']['error']);
                switch ( $_FILES['csv_file']['error'] )
                {
                    case UPLOAD_ERR_INI_SIZE:
                        $this->setErrorMessage( OW::getLanguage()->text('csvimporter', 'upload_error_ini_size') );
                        break;
                    case UPLOAD_ERR_FORM_SIZE:
                        $this->setErrorMessage( OW::getLanguage()->text('csvimporter', 'upload_error_form_size') );
                        break;
                    case UPLOAD_ERR_PARTIAL:
                        $this->setErrorMessage( OW::getLanguage()->text('csvimporter', 'upload_error_partial') );
                        break;
                    case UPLOAD_ERR_NO_FILE:
                        $this->setErrorMessage( OW::getLanguage()->text('csvimporter', 'upload_error_no_file') );
ross Team
ross Feb 26 '15
Please check in ow_log/error_logs file
esskay
esskay Feb 27 '15

This is what in ow_log/cron_error.log -


[Thu Feb 26 11:58:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_HOST - assumed 'OW_DB_HOST' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:206
[Thu Feb 26 11:58:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_USER - assumed 'OW_DB_USER' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:207
[Thu Feb 26 11:58:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_PASSWORD - assumed 'OW_DB_PASSWORD' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:208
[Thu Feb 26 11:58:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_NAME - assumed 'OW_DB_NAME' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:210
[Thu Feb 26 11:58:04 2015] [ow_core_log] [Exception] Message: SQLSTATE[HY000] [2005] Unknown MySQL server host 'OW_DB_HOST' (2) File: /var/www/vhosts/mysite.com/httpdocs/ow_core/database.php Line:223 Trace: [#0 /var/www/vhosts/mysite.com/httpdocs/ow_core/database.php(253): OW_Database->__construct(Array) | #1 /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php(230): OW_Database::getInstance(Array) | #2 /var/www/vhosts/mysite.com/httpdocs/ow_core/base_dao.php(47): OW::getDbo() | #3 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_dao.php(66): OW_BaseDao->__construct() | #4 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_dao.php(55): BOL_ConfigDao->__construct() | #5 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_service.php(63): BOL_ConfigDao::getInstance() | #6 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_service.php(52): BOL_ConfigService->__construct() | #7 /var/www/vhosts/mysite.com/httpdocs/ow_core/config.php(48): BOL_ConfigService::getInstance() | #8 /var/www/vhosts/mysite.com/httpdocs/ow_core/config.php(68): OW_Config->__construct() | #9 /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php(167): OW_Config::getInstance() | #10 /var/www/vhosts/mysite.com/httpdocs/ow_cron/run.php(48): OW::getConfig() | #11 {main}]
[Thu Feb 26 11:59:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_HOST - assumed 'OW_DB_HOST' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:206
[Thu Feb 26 11:59:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_USER - assumed 'OW_DB_USER' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:207
[Thu Feb 26 11:59:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_PASSWORD - assumed 'OW_DB_PASSWORD' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:208
[Thu Feb 26 11:59:01 2015] [ow_core_log] [Notice] Message: Use of undefined constant OW_DB_NAME - assumed 'OW_DB_NAME' File: /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php Line:210
[Thu Feb 26 11:59:01 2015] [ow_core_log] [Exception] Message: SQLSTATE[HY000] [2005] Unknown MySQL server host 'OW_DB_HOST' (2) File: /var/www/vhosts/mysite.com/httpdocs/ow_core/database.php Line:223 Trace: [#0 /var/www/vhosts/mysite.com/httpdocs/ow_core/database.php(253): OW_Database->__construct(Array) | #1 /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php(230): OW_Database::getInstance(Array) | #2 /var/www/vhosts/mysite.com/httpdocs/ow_core/base_dao.php(47): OW::getDbo() | #3 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_dao.php(66): OW_BaseDao->__construct() | #4 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_dao.php(55): BOL_ConfigDao->__construct() | #5 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_service.php(63): BOL_ConfigDao::getInstance() | #6 /var/www/vhosts/mysite.com/httpdocs/ow_system_plugins/base/bol/config_service.php(52): BOL_ConfigService->__construct() | #7 /var/www/vhosts/mysite.com/httpdocs/ow_core/config.php(48): BOL_ConfigService::getInstance() | #8 /var/www/vhosts/mysite.com/httpdocs/ow_core/config.php(68): OW_Config->__construct() | #9 /var/www/vhosts/mysite.com/httpdocs/ow_core/ow.php(167): OW_Config::getInstance() | #10 /var/www/vhosts/mysite.com/httpdocs/ow_cron/run.php(48): OW::getConfig() | #11 {main}]

ross Team
ross Feb 27 '15
Esskay, please check whether you have zlib and zip modules installed on your server. 

Also what do you have in ow_includes/config.php file here for the value of the constant:

define('OW_DB_HOST', 'THIS VALUE'); ?

esskay
esskay Mar 4 '15
1. what do you have in ow_includes/config.php file here for the value of the constant:define('OW_DB_HOST', 'THIS VALUE');

I have localhost

2. Result of dpkg-query -l zlib is dpkg-query: no packages found matching zlib

3. Result of dpkg-query -l zip is ii  zip            3.0-8        amd64        Archiver for .zip files

This is what you wanted...?

The Forum post is edited by esskay Mar 4 '15
ross Team
ross Mar 4 '15
Esskay, can you please check you phpinfo and provide screenshots where it says zlib and zip modules are enabled. As I could not find what the comamand you use does
esskay
esskay Mar 4 '15
Screenshot attached....
Attachments:
  oxwall_ScreenShots.doc (184Kb)
ross Team
ross Mar 4 '15
I will need access details to your server via FTP and admin details for the website in PM, please. 
esskay
esskay Mar 4 '15
PM sent.....
esskay
esskay Mar 5 '15
Hi...


Any update on this.....?

ross Team
ross Mar 5 '15
Esskay, we found out that while downloading the csv file, the type of the file changes, which is why you get this error. We'll provide you with the fix asap. Most probably next week. Thank you for your patience. 
esskay
esskay Mar 6 '15
Thank you Ross....waiting for the fix...
Pages: 1 2 »