PDA

View Full Version : screwing with table datastore?


WA007
10-17-2005, 05:10 PM
Hello, I have a problem with the "post" icon, its just no longer there when I install cmps causing the text to start right under the blue bar

I have compared a database post-cmps with a database pre-cmps and found that the installation is removing something from the datastore table.

it was missing in table datastore, then a row with the title "options" and it was missing in the data

"showdeficon";s:22:"images/icons/icon1.gif";s:8:"wordwrap" <-- good

"showdeficon";s:0:"";s:8:"wordwrap" <-- missing

data is much more in that table, but this is the small part that screws the icon

To explain better, compare THIS (http://213.10.250.118/forum/showthread.php?p=67251) with THIS (http://213.10.250.118/backup.forum/showthread.php?p=67248) and pay attention to the missing http://www.xtcomputing.com//images/icons/icon1.gif icon

I can fix this locally, how should I fix it online where I have no phpadmin available?

KW802
10-17-2005, 05:22 PM
WA007,

I'll leave it up to Brian to answer whether CMPS may have done anything to that field but to fix it....

Try going into your ACP then vBulletin Options => Thread Display Icons (showthread) => Show Default Post Icon and seeing if a value is present; if not restore it back to your icon1.gif image.

Our Sponsors
 

WA007
10-18-2005, 01:25 AM
Great thanks that fixed it.

I'm sure the install did it cause I made a backup of the database before I installed and there was nothing else I changed, I can replicate the problem easy by starting with a fresh vbulletin db, put back the backup

mysql -p -u<youruserid> <yourdbname> < backupname.sql

then the icon will show, then I install CMPS 1.01 and the icon is gone.. nothing else done, its something I checked before posting here.

Anyways I didnt know where this post icon option was accept by looking for it using a search for icon1.gif in the database.

I do have another thing the users discovered, I'm suddenly missing a thread, no trace of it in the loggs that anyone modded it.. have there been bug reports about missing threads when installing CMPS before?

KW802
10-18-2005, 01:51 AM
CMPS 1.0.1 or CMPS 2.0.0?

Missing threads... that I've never heard of before. No chance that anybody with mod' permissions did a physical delete on it instead of a soft delete?

Our Sponsors
 

WA007
10-18-2005, 08:25 AM
missing thread is found, I have overlooked it in the loggs.

I installed CMPS 1.0.1 yes (from vbulletin.org) I only saw later theres 2.0.0 here and havent upgraded (yet)