Support for mysqli
Sc0tt - October 31, 2009 - 22:55
| Project: | DataSync |
| Version: | 6.x-1.0-beta1 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
Just got the "WARNING: You are using the mysqli database type. This likely won't work and will create lots of weird errors. You must use the mysql database type."
Are there any plans to support mysqli?
Thank you,
Scott
#1
The reason I added that message was that I was having trouble with the mysqli driver and the PHP fork() function. It appeared to be a bug in the mysqli driver.
If you (or anyone) can test datasync with mysqli and verify that this bug is fixed, then maybe I can remove this message.
#2
Thanks for the reply Andrew.
I tried using DataSync w/ mysqli. The module installed just fine but before having a chance to set up any jobs, I got the error
Fatal error: Cannot use string offset as an array in /home/fillmor1/public_html/newsite/includes/form.inc on line 984while trying to access admin/settings/datasync/schedule.In an effort to isolate the cause of the error, I discovered that deactivating the DataSync_feedAPI module resulted in no errors. Since using DataSync_feedAPI is the main reason I am using DataSync, I thought I would stop right here and let you know what I discovered after noticing you are the author of both modules.
I saw nothing obviously related to this error in my log entries. Let me know if there is anything I can do you help you diagnose what might be happening.
I'm excited about using DataSync since I estimate that we will be importing data from over 100 RSS feeds, and currently with only about 30 feeds, I'm constantly getting cron errors.
Thank you for your modules and your help,
Scott
PS. I'm using:
Drupal 6.14
CTools CSS Cache Exists
MySQL database 5.0.77mm0.1
PHP 5.2.9
PHP memory limit 96M
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Web server Apache/1.3.41 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.31 OpenSSL/0.9.8b mod_status/0.2mm
cURL Library 7.15.5
jQuery UI 1.6
#3
Scott,
This looks like the same issue as http://drupal.org/node/535642 which I could not reproduce. Would you be willing to help me diagnose this?
Please put
<?phpif (strpos($form_id, 'datasync') !== FALSE) print_r(debug_backtrace());
?>
(without the php tags) on line 983 of form.inc (right before the error) and then attach a txt file with that output to the issue (preferably the one linked above). Thanks!
#4
Thanks Andrew,
I am not an engineer so I hope I've accomplished what you've requested. Here is what I did:
(1) inserted your code on the line you requested.
(2) pointed my browser to /admin/settings/datasync/schedule.
(3) copied the output on the screen to a text file.
(4) attached that text file to this comment.
(5) provide you with a like to the live site: http://www.newsite.fillmoregazette.com/admin/settings/datasync/schedule
Until I hear from you, I will leave your code in place on the live site. I'm happy to give you full access to the site if you need it. Please let me know if there is anything else I can do to help.
Thanks again,
Scott
#5
Scott,
It would help a lot if you could give me ssh access to your development server (and your permission to modify the datasync files in order to debug) in addition to an admin account on your development site.
If that's possible please send that information to me through my contact form: http://drupal.org/user/49940
Otherwise I will try to figure it out from your output.
Andrew
#6
Will contact you via personal contact form.
Thanks Andrew.