PhotoPlog

PhotoPlog (http://www.photoplog.com/forum/index.php)
-   "How Do I..." Questions (http://www.photoplog.com/forum/forumdisplay.php?f=7)
-   -   Easy: How do I change table prefix for photoplog? (http://www.photoplog.com/forum/showthread.php?t=992)

camel101 02-18-2007 12:12 AM

Easy: How do I change table prefix for photoplog?
 
I would like it to be XX_photoplog instead of photoplogxxxx?

I'm trying to see if i can get it to work with the zoints block.

Code:

Database error in vBulletin 3.6.4:

Invalid SQL:

                        SELECT * FROM vb_photoplog_fileuploads
                        WHERE userid=1
                        AND moderate=0
                        ORDER BY dateline DESC
                        LIMIT 7;

MySQL Error  : Table 'maindb.vb_photoplog_fileuploads' doesn't exist
Error Number : 1146
Date        : Saturday, February 17th 2007 @ 06:57:47 PM
Script      : http://www.domain.com/board/z/index.php?z-profile=ED2CHAT
Referrer    : http://www.domain.com/board/z/zadmin.php?cmd=blocks&tabid=0
IP Address  : XXXXXXXXXXXXX
Username    : XXXXXXX
Classname    : vb_database

I love photoplog it's very simple so i do not want to get anything besides it.
Everything else is beyond our members technicality. It's simple for them at least to post without all the bells and whistles.:)

Morgan 02-18-2007 12:49 AM

PhotoPlog Lite doesn't have a prefix option. Rather photoplog_ is the prefix. If you wanted vb_photoplog_ as the prefix, you'd have to edit the query related code and rename the tables so they have the new prefix. It might be easier to simply remove the following from the query in the Zoints block, assuming it's there:
Code:

" . TABLE_PREFIX . "

camel101 02-18-2007 02:05 AM

1 Attachment(s)
You are awesome! solved in 2 seconds removing that line of code did it!
:)

Thank You!


All times are GMT. The time now is 03:44 PM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.