Firefox PHP

Moving Phorum

Posted by pacho_bg2 
Re: Moving Phorum
February 22, 2011 01:22PM
I am not very good at explaining things.

I assume to move your Phorum you dumped the data, and structure, then imported the data. If the tables don't exist they are created. When the tables are created MySql will use whatever it has set as a default character set, unless you specify it when you create the tables. Earlier versions of Phorum did not specify a character set on a new install, and the default MySql character set is used.

You should verify what was used previously, before the move.
From PhpMyAdmin dump a structure only (from the new phorum) and see what character set is being used. See the last line of this example (not from a Phorum). You would want to see utf8, and probably not latin1
Language: SQL
CREATE TABLE `lcc_linkcats` ( `lcc_id` INT(11) NOT NULL AUTO_INCREMENT, `lcc_cat` VARCHAR(64) NOT NULL, PRIMARY KEY (`lcc_id`), UNIQUE KEY `lcc_cat` (`lcc_cat`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
Here is the last line from another structure dump.
Language: SQL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=16543 ;
Re: Moving Phorum
February 25, 2011 02:53AM
Thank you, I fixed the problem. The tables were set to Bulgarian characters, because I didn't make the forum on the previews hosting i had some unknowns. And another question look here, at the bottom of the firs post it's trying to display an image an i went trough all php files and couldn't find where it is defined. I want to remove it, I don't need it to show, but I can't remove it or get it to show. Thank you!
Re: Moving Phorum
February 25, 2011 08:14AM
Only a guess.
Look at the users profile--- in their "signature".
Re: Moving Phorum
February 25, 2011 08:42AM
that user is me, and this image tries to show only after editing the message
Re: Moving Phorum
February 25, 2011 09:42AM
It would appear you need to search all of the files for "edited".
I use Textpad as an editor, it finds 22 occurrences in 9 files (Phorum 5.2.16) with only english language file.

There is a mod for suppressing the "Edited Message", I do not know what other options it has available.

Search for the string "mamun.gif" in the files, if you do not locate it it may be in one of the tables.
Re: Moving Phorum
February 26, 2011 08:18AM
I ran a search and didn't find anything it is probably in the tables. Tried the mod you recommended, gives me an error at page load. Is there a way to remove the edit message entirely. Thanks for the help
Re: Moving Phorum
February 26, 2011 11:16AM
At the moment, I can't get to your forum. I can get to the login page, but when I attempt to register, I get a screen dump of all of the variables.
This is a bad thing when exposed to the www. The dump of all of the variables indicates there are several mods active. You might disable them temporarily to see if anything changes (screen dump goes away).
Re: Moving Phorum
February 27, 2011 07:49AM
Yes thanks i haven't notice that, it was the "forum lock down" mod. And i found a solution to the other problem as well. It was specified in a "Simple Text Replacement Mod" to change "@" symbol with the picture :)
Sorry, only registered users may post in this forum.

Click here to login