When I upgraded the CTools/Panels modules, I got an error message stating something to the effect of 'The export definition of data_tables is missing the "primary key" property.'. When I look at the schema for data_tables, there is a key but no associated primary key. I'm not quite sure on what the resolution on this would be other than adding a primary key to the table (would it need to be specified in the schema as well)?
| Comment | File | Size | Author |
|---|---|---|---|
| #13 | MNfeedSS.jpg | 78.29 KB | defendthecommons |
| #10 | 866476_10.patch | 751 bytes | David Goode |
| #7 | 866476-6_CTools1.7.patch | 1.47 KB | alex_b |
Comments
Comment #1
Anticosti commentedsubscribing
Comment #2
Maitreya commentedsubscribing
Comment #3
andreic commentedsubscribing
Comment #4
alex_b commentedThat may be it.
Yes.
I won't be able to look at this right away. Anybody up for a patch?
Comment #5
btmash commentedI'll try and write up a patch today.
Comment #6
alex_b commentedHa, I just got a fix. One min.
Comment #7
alex_b commentedThis should fix it. More testing now before I commit it.
Comment #8
alex_b commentedThis is committed now - thank you.
Comment #10
David Goode commentedThrows an error on update due to caching of the schema and subsequent views menu rebuild callbacks to data; this clears the cache and removes that problem. It is a patch to the new CVS head, which includes the previous patch.
Comment #11
alex_b commented'insult to injury' - LOL
I feel a little queasy about using the CTools API in the update hook, but I don't see alternatives. RTBC
Comment #12
defendthecommons commentedHi Gents,
Great work!
Are you sayin that one just needs to patch with 866476_10.patch, or patch with it after?
My first time patching. ssh'd in and tried it first with 866476-6_CTools1.7.patch and it errord.
Then tried
Any advice?
After I figure this out, I need to figure out why after watching the great screencast about changing location.csv files, and deleting the stock country location data, uploading my own of all california cities and lat lons, my 2 simple points from google news RSS no longer appear like they first did, and I get a "error during map rendering"... I've cleared caches "delete from cache" in SQL of PHPMyAdmin and reloaded the "mn_world.csv" file and still no rendering... cleared cache data in Performance settings... I increased my php memory from 64 to 128.
.. all because my San Jose CA story was mapped to San Jose, Costa Rica. ;)
Mac OS X
Firefox 3.5 - error during map rendering (SHIFT-CMD-R)
Safari 3.0.4 - shows world map repeated zoomed out to the moon, no points
SeaMonkey - error during map rendering
Can't wait to work with this,
-D
PS: related? http://drupal.org/node/612782
RSS feeds not valid (Error when aggregating MN feeds with aggregator module)
------------
http://pollinatethis.org/mappingnews
MN beta10, Security updates only to: Views 6.x-2.11, Rubik 6.x-3.0-beta1, Tao 6.x-3.1
Drupal6.19
Access to update.phpProtected
CTools CSS CacheExists
Configuration fileProtected
Cron maintenance tasksLast run 2 min 2 sec ago
MySQL: 5.0.91
PHP: 5.2.5
PHP memory limit: 128M
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Web server: Apache
jQuery UI: 1.6
shared hosting: Hostrocket (errr)
Comment #13
defendthecommons commentedUPDATE
I deleted and re-created my google news feed of 2 items.
The little map in the bottom appears with the items mapped!
But not on front page in any browser, just in Feeds page of Admin.
attached jpg
I also get these errors...
Comment #14
David Goode commentedMake sure you're attempting to patch the CVS head or relevant version of the module you're dealing with. This really isn't related to this particular thread though; CTools is a totally separate module, to which this patch doesn't apply, and yours is a support request. Look at Drupal's guide for CVS checkouts of modules and such, like here http://drupal.org/handbook/cvs/quickstart or google... This will probably be released in the not too distant future anyway with the new release of MN.
Comment #15
defendthecommons commentedHm. I came to this thread because I had the same problem after updating to ctools1.7 and I got the same error as the original poster BTMash. 'The export definition of data_tables is missing the "primary key" property.'
I saw the patches here which appear to fix the problem. Perhaps I'm not applying them correctly? I think this is the right thread. Why aren't we on the same page? I just want to fix this table and it seems that the patch does it. Why does the patch "866476-6_CTools1.7.patch" not apply to CTools? You lost me.
?
Comment #16
defendthecommons commentedWell, for the record, I solved my problem by
reverting back to ctools 1.3
refreshing, emptying cache
deleting all my locations
adding my CAL locations list (1200+ places)
deleting my RSS feed
re-creating the RSS feed, seeing my stories mapped correctly in San Jose, CA, not San Jose, Costa Rica, woooho
then needed to fix the front page map "error on render" by deleting the block for the map and recreating it by dragging it from the Dashboard menu back into place on the left side and setting it up.
That fixed it. I guess it's a browser thing???
There are many caching things I don't understand. I was always bypassing my browser cache upon refreshing.
Great work, folks. Thanks again for making it all happen.
Comment #17
alex_b commentedTo be released with 6.x-1.0-alpha13.
Comment #18
alex_b commentedThis is committed, thank you.