Subscribe: Comments for FastPipe Media, Inc.
http://www.fastpipe.com/comments/feed/
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
comment converting  comment  converting xdforum  count  date  mysql  select  sql  time  topic count  topic  version  view  xdforum bbpress  xdforum 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Comments for FastPipe Media, Inc.

Comments for FastPipe Media, Inc.



Internet Plumbing



Last Build Date: Thu, 28 Aug 2008 18:55:49 +0000

 



Comment on Converting XDForum to BBPress by clicknathan

Thu, 28 Aug 2008 18:55:49 +0000

My bad, I /was/ using a 4.x version of MySQL, though the "MySQL client version 5.0.41" in phpMyAdmin thing was a bit of a throw off for the novice such as myself.



Comment on Converting XDForum to BBPress by clicknathan

Thu, 28 Aug 2008 00:41:02 +0000

The Select statement seems to work (in that it doesn't return an error). I'm using MySQL 5.0.41 I'm not that schooled at SQL in general - should I be trying to run this from the main SQL tab or from inside one of the tables. (Maybe that doesn't even matter....) Thanks for your reply!



Comment on Converting XDForum to BBPress by FastPipe Media, Inc.

Thu, 28 Aug 2008 00:30:11 +0000

It could be that your server is using an earlier version of MySQL as views were introduced in version 5. However, the SQL statement you posted was after a view had been used earlier so probably not. Does just the select statement work for you? SELECT xp_xt_id AS topic_ID, COUNT(xp_xt_id) AS my_count, xp_author_ip AS author_ip, FROM_UNIXTIME( MIN( xp_date ) ) AS post_time, FROM_UNIXTIME( MAX( xp_date ) ) AS last_post_time FROM wp_xdforum_posts GROUP BY xp_xt_id ORDER BY xp_xt_id, post_time DESC If that works, then most likely you're using a version of MySQL that doesn't support subselects. If that's the case, you'll have to figure out how to recreate the view into a temporary table so you can update the counts, which is the whole purpose of the view, which just displays the number of items in the thread, the date the topic was started and the date it was last updated.



Comment on Converting XDForum to BBPress by clicknathan

Wed, 27 Aug 2008 23:45:50 +0000

Howdy there. Great job sorting this out! I've been trying to work through your instructions and got hung up on step 7. I get an SQL syntax error, which I'll paste below. Any chance you might know what I'm doing wrong? Error SQL query: Documentation CREATE VIEW topic_info AS SELECT wp_xdforum_posts.xp_xt_id AS topic_ID, COUNT( wp_xdforum_posts.xp_xt_id ) AS my_count, xp_author_ip AS author_ip, FROM_UNIXTIME( MIN( xp_date ) ) AS post_time, FROM_UNIXTIME( MAX( xp_date ) ) AS last_post_time FROM wp_xdforum_posts GROUP BY xp_xt_id ORDER BY xp_xt_id, post_time DESC MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW topic_info AS SELECT wp_xdforum_posts.xp_xt_id AS topic_ID, COUNT(wp_xdforu' at line 1



Comment on A Cloudy Day… by HDTV In Oklahoma » Putting HDTV on the Map in Oklahoma » HD Time Lapse Movies

Sun, 30 Jul 2006 07:34:37 +0000

[...] We continue experimenting with our Sony HDR-HC3 high definition camcorder. One of the things you see all the time these days are time lapse movies of clouds zooming across the sky. Although it was 104 degrees, the clouds today were perfect for capturing this kind of footage. Of course, I still haven’t found time to write a review of the camera… [...]



Comment on High Definition Fireworks by HDTV In Oklahoma » Putting HDTV on the Map in Oklahoma » HD Fireworks

Thu, 06 Jul 2006 07:00:33 +0000

[...] I’ve posted a short fireworks video on my main site that I shot using my Sony HDR-HC3 High-Definition Handycam Camcorder tonight for those of you who missed the fireworks in your own town last night. [...]



Comment on HDTVok.com Gets a Facelift! by Dana

Mon, 03 Jul 2006 16:18:00 +0000

Dennis, your site looks great. I like the new look and features.