Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database errors when using WordPress 2.3 #75

Closed
GoogleCodeExporter opened this issue Apr 4, 2015 · 25 comments
Closed

Database errors when using WordPress 2.3 #75

GoogleCodeExporter opened this issue Apr 4, 2015 · 25 comments

Comments

@GoogleCodeExporter
Copy link

Using WordPress 2.3 and GeoMashup 1.1b1 

Since upgrading to WordPress 2.3, I am getting the following WordPress
error on any page that contains the GeoMashup plugin output:

WordPress database error: [Table 'expedit4_amazonas.wp_categories' doesn't
exist] 
SELECT * FROM wp_categories

URL example: http://www.expeditionamazonas.com/the-route/

This is also happening on the plugin options page within WordPress admin.



Original issue reported on code.google.com by dmcdon...@gmail.com on 1 Oct 2007 at 5:23

@GoogleCodeExporter
Copy link
Author

I have the same issue.  Just installed the plugin on WP 2.3...  presume a table 
has
been renamed between WP versions?

Original comment by rjvspamf...@gmail.com on 4 Oct 2007 at 8:03

@GoogleCodeExporter
Copy link
Author

These updates seem to work for me. Anyone like to verify that for me?

Original comment by dylankk...@gmail.com on 11 Oct 2007 at 12:18

  • Changed state: Fixed

Attachments:

@GoogleCodeExporter
Copy link
Author

Hi, that certainly seems to have cleared the errors I was getting.  But I'm also
getting a blank page - which is unsurprising as I was only part way through 
setting
things up and wouldn't expect more at this stage.  But its looking promising.

Will post back soon with an update.  Thanks for taking a look at the queries :-)

Original comment by rjvspamf...@gmail.com on 11 Oct 2007 at 11:25

@GoogleCodeExporter
Copy link
Author

Yes, seems to work - I have a map and a pin on it from a test blog entry with a
location in it.

Good work !

Thanks.

Original comment by rjvspamf...@gmail.com on 11 Oct 2007 at 11:36

@GoogleCodeExporter
Copy link
Author

It may be necessary to re-set and save the category colors & zoom level options.

Original comment by dylankk...@gmail.com on 12 Oct 2007 at 1:12

@GoogleCodeExporter
Copy link
Author

Got it finished off today, got pins, posts and excerpts all working.  The blank 
map
was because I hadn't even looked at the zoom level options.  Was just a case of
zooming in.

Only slight issue is that it shows a map view even if I choose hybrid or 
satellite.

Excellent plugin though - thanks :-)

Original comment by rjvspamf...@gmail.com on 12 Oct 2007 at 1:29

@GoogleCodeExporter
Copy link
Author

Thanks for the test. You might find that if you restart your browser the 
default map
type will take effect. Once you browse around on a map, the plugin will try to 
take
you back to the map type and location you were looking at before.

Original comment by dylankk...@gmail.com on 12 Oct 2007 at 1:46

@GoogleCodeExporter
Copy link
Author

Hi, I've discovered a couple of issues - not sure if they're related to the 
query/db 
issues or if they're seperate.

1) when the categories box is ticked in the preferences, the code which is 
added to 
the sidebar appears to be missing a close " (after the title="... attribute) so 
the 
following HTML isn't formatted properly.

2) the links it inserts with "...?map_cat=1&zoom=9" when visited load the page, 
but 
the geomashup map is blank/greyed out - the google logo is visible, but the map 
is 
blank - there also appears to be a javascript error at the bottom of the 
browser 
window.

Rob.

Original comment by rjvspamf...@gmail.com on 12 Oct 2007 at 8:59

@GoogleCodeExporter
Copy link
Author

Rob, I'm not getting that error - do you mind sharing your URL?

Original comment by dylankk...@gmail.com on 12 Oct 2007 at 9:20

@GoogleCodeExporter
Copy link
Author

[deleted comment]

@GoogleCodeExporter
Copy link
Author

the mashup is on a private page, so you can't see it unless you're logged in - 
as 
the site is live.

I've (hopefully) emailed you an id, presuming I've guessed your email 
correctly..
Rob

Original comment by rjvspamf...@gmail.com on 13 Oct 2007 at 8:39

@GoogleCodeExporter
Copy link
Author

the default map type doesn't work for me either (always shows Roadmap). see:
http://www.gueba.de/reisen/
the default zoom level does not work properly, if left blank or set to 0. (1 to 
17
works as expected)

@ 1)    experienced a similar problem at first test but now it's gone (maybe an
ftp-error?)
@ 2)    blank/greyed out map shows, when Single Category Zoom Level is not set 
in the
options page (link shows "...?map_cat=1&zoom=")

gueba

Original comment by guent...@gueba.de on 13 Oct 2007 at 12:36

@GoogleCodeExporter
Copy link
Author

found solution for default map type:
in  geo-mashup.php line 273 must be

mapType:'.$geoMashupOpts['map_type'].',

instead of

mapType:"'.$geoMashupOpts['map_type'].'",

gueba

Original comment by guent...@gueba.de on 13 Oct 2007 at 12:54

@GoogleCodeExporter
Copy link
Author

Thanks Gueba - unfortunately the quotes there are part of a previous bugfix. 
I'll
have to do some debugging to see what's going on.

Original comment by dylankk...@gmail.com on 13 Oct 2007 at 2:09

@GoogleCodeExporter
Copy link
Author

Wait! That's the problem - I did another fix that requires geo-mashup.js also. 
Let's
add that to the mix and try again.

Original comment by dylankk...@gmail.com on 13 Oct 2007 at 2:32

Attachments:

@GoogleCodeExporter
Copy link
Author

works now at http://www.gueba.de/reisen

Thank you, you're doing an excellent job, Dylan

Original comment by guent...@gueba.de on 13 Oct 2007 at 4:08

@GoogleCodeExporter
Copy link
Author

Sorry for going on your nerves, but I found a strange behavior:
if you have a link specified with the same 'link_id' as the 'post_id', the
pop-up-info shows the category that is assigned to the post and also the
link_category that is assigned to the corresponding link. 
See http://www.gueba.de/reisen for example: the orange pin at New Zealand is 
created
in post_id 12, which is assigned to category 5. The corresponding link is
'link_id_12, assigned to (Link-)Category cat_id_8.
would it be possible to filter out the link-categories?

regards,
gueba

Original comment by guent...@gueba.de on 14 Oct 2007 at 4:14

@GoogleCodeExporter
Copy link
Author

I appreciate that kind of testing - I did mean to only list post categories. 
Will you
try the attached change?

Original comment by dylankk...@gmail.com on 14 Oct 2007 at 4:21

Attachments:

@GoogleCodeExporter
Copy link
Author

this seems to fix the problem with posts in categories, but not with posts in 
pages.
please see the pin in North America on my testpage. It is posted in page_id 10, 
which
is named 2010 and it shows categories to 'Allgemein' (the standard category), 
which
is wanted, I suppose and 'test', which is link-category 7. The link "EHC 
Straubing"
has the link_id 10 and is assigned to link-categories 2 (Blogroll), 7 (test) 
and 8
(cat_id_8).

Original comment by guent...@gueba.de on 14 Oct 2007 at 5:29

@GoogleCodeExporter
Copy link
Author

I'm not sure I see the problem you describe, but I did see one more place where 
I
needed to limit a query to just categories. Any chance that helps?

Original comment by dylankk...@gmail.com on 14 Oct 2007 at 5:59

Attachments:

@GoogleCodeExporter
Copy link
Author

Sorry, my fault! The only problem was sitting in front of my computer. I guess I
mixed up the post-content with the given categories, stupid me! I apologize! 
Both
files work with no difference, it seems, thank you.

gueba

Original comment by guent...@gueba.de on 14 Oct 2007 at 6:16

@GoogleCodeExporter
Copy link
Author

Not a problem - your attention has helped prevent future problems and improved 
the
next release. Cheers!

Original comment by dylankk...@gmail.com on 14 Oct 2007 at 7:01

@GoogleCodeExporter
Copy link
Author

I still didn't have it right. I was using the wrong field for category ID in 
the new
schema. I think these are finally right.

Original comment by dylankk...@gmail.com on 14 Oct 2007 at 9:47

Attachments:

@GoogleCodeExporter
Copy link
Author

The updates work great...thanks.

Original comment by limestar...@gmail.com on 15 Oct 2007 at 3:22

@GoogleCodeExporter
Copy link
Author

Original comment by dylankk...@gmail.com on 23 Aug 2008 at 5:56

  • Changed state: Verified

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant