feedapi.install has a couple problems regarding PostgreSQL support. Please see attached patch fro fixes.
- {} table prefix brackets are missing in PostgreSQL table creation SQL for feedapi_stats table
- MySQL feedapi_stats has 1 index created on 4 fields, PostgreSQL feed_api stats has 4 indexees created on each of the 4 fields individually. I assume that the MySQL index is the indented index.
- added update_7 function to handle index issue above
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | feedapi.install.patch | 2.37 KB | jaydub |
| feedapi.install.patch | 2.36 KB | jaydub |
Comments
Comment #1
jaydub commentedignore previous patch. fixed issue in the update_7
Comment #2
alex_b commentedassign to right project.
Comment #3
aron novakI committed the patch, thank you for the ready-to-use patch. In fact, i had to modify a small thing in the patch. In the update() query, the index creation was not the same as in the main install().
Comment #4
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.