You are not logged in. Please login or register.
PunBB Forums → Posts by AlexS
Pages 1
What sort of box element is it?
A div?
Are you using CSS to do it?
--Alan
Ideally, I would like users to be able to do it just with bbCode, using "quote" boxes, or whatever is possible to achieve it...
Hello,
I need to write text in a box which is not immediately readable. So something that would work is white text in a white box, or black text in a black box (the box is usefull to show that there is text, so that readers know that they can read it if they highlight it). I can easily color text, but how to I color the box (quote tag)?
This is some text
This is more text
As you see, I can make it work, but I can't define the background color of the box, and so if someone changes the skin, the effect is lost...
Thanks Rickard, you're dead right!
I now managed to correctly display the à character. Thanks a lot!!
I already mentioned this problem, but I'm opening a new thread to make things more clear and easy for people willing to help me.
When I do a fresh install of punbb (version 1.2.12) on a Linux Debian server ( PHP: 4.4.2-1.1, MySQL 5.0.22), I can't type correctly some characters.
The problem is show in this post, but basically the "à" character becomes "?"
The mysql database was freshly created for this test forum.
I did a mysql dump of this test forum, here is an excerpt:
DROP TABLE IF EXISTS `trialpunbb_forums`;
CREATE TABLE `trialpunbb_forums` (
`id` int(10) unsigned NOT NULL auto_increment,
`forum_name` varchar(80) NOT NULL default 'New forum',
`forum_desc` text,
`redirect_url` varchar(100) default NULL,
`moderators` text,
`num_topics` mediumint(8) unsigned NOT NULL default '0',
`num_posts` mediumint(8) unsigned NOT NULL default '0',
`last_post` int(10) unsigned default NULL,
`last_post_id` int(10) unsigned default NULL,
`last_poster` varchar(200) default NULL,
`sort_by` tinyint(1) NOT NULL default '0',
`disp_position` int(10) NOT NULL default '0',
`cat_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Maybe the problem is the latin1 encoding, I don't know. But my locale gives the following:
$ locale
LANG=pt_PT.UTF-8
LC_CTYPE="pt_PT.UTF-8"
LC_NUMERIC="pt_PT.UTF-8"
LC_TIME="pt_PT.UTF-8"
LC_COLLATE="pt_PT.UTF-8"
LC_MONETARY="pt_PT.UTF-8"
LC_MESSAGES="pt_PT.UTF-8"
LC_PAPER="pt_PT.UTF-8"
LC_NAME="pt_PT.UTF-8"
LC_ADDRESS="pt_PT.UTF-8"
LC_TELEPHONE="pt_PT.UTF-8"
LC_MEASUREMENT="pt_PT.UTF-8"
LC_IDENTIFICATION="pt_PT.UTF-8"
LC_ALL=pt_PT.UTF-8
Also, when I use the "Example" plug-in to introduce text, the following displayed text is correct.
Finally, and last piece of information, when I imported a previous punbb database (also formatted in latin1), the contents were correctly displayed in the forum). It's only the new records which are mangled.
Ok, so I decided to start from scratch, and I dumped the new DB
But this time, instead of just creating the table ochipepe_LRforum, I used the following command:
CREATE DATABASE `ochipepe_LRforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;
and then injected the backed up DB
When I check the dump, I see the following:
-- MySQL dump 10.10
--
-- Host: localhost Database: ochipepe_LRforum
-- ------------------------------------------------------
-- Server version 5.0.22-Debian_3-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `forum1_bans`
--
DROP TABLE IF EXISTS `forum1_bans`;
CREATE TABLE `forum1_bans` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(200) collate latin1_general_ci default NULL,
`ip` varchar(255) collate latin1_general_ci default NULL,
`email` varchar(50) collate latin1_general_ci default NULL,
`message` varchar(255) collate latin1_general_ci default NULL,
`expire` int(10) unsigned default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
...First, somehow it seems SET NAMES is in UTF8, despite my command.
Second, the tables are created as latin1_general_ci, so that should be fine
However, I still have the same problem with my forum: the menus are mangled, the new posts also, but not the old ones.
Now I'm totally lost. Any ideas?
Did phpMyAdmin do the conversion in a smart way, or did it mangle completely the text? Did you check that?
Ok, I looked at an SQL back up of my previous database, and I find this:
-- CREATE DATABASE `lune_rouge` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;
-- USE lune_rouge;
-- --------------------------------------------------------
--
-- Structure de la table `forum1_bans`
--
CREATE TABLE `forum1_bans` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(200) collate latin1_general_ci default NULL,
`ip` varchar(255) collate latin1_general_ci default NULL,
`email` varchar(50) collate latin1_general_ci default NULL,
`message` varchar(255) collate latin1_general_ci default NULL,
...So the previous encoding was latin1
When I do a dump of my current mysql db I get:
-- MySQL dump 10.10
--
-- Host: localhost Database: ochipepe_LRforum
-- ------------------------------------------------------
-- Server version 5.0.22-Debian_3-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;So I think now it's utf8...
If that's so, is there an easy way out, or should I dump the database and start the recovery from scratch?
Also, I would like the database to be encoded in utf-8, to avoid such problems in the future. Is there a way of doing that?
You should be able to see this in phpMyAdmin.
My server does not have phpMyAdmin installed, so I'm forced to do direct mysql commands, which complicates my life. I'm trying to find out how to get that info
So do I, and it looks horrible
Actually you made me have a closer look at it, and when I see the forum, it looks exactly like this one (forums.punbb.org), except I'm using the Lithium theme. The font is also the same size, so I don't get what's the problem? That's strange, I'll ask other users for their feed back. But this is besides the point.
Check what the default encoding of your database is.
Do you know which command should I issue?
[
What's up with the huge text size? >=/
We use big screens 
Anyway, the message preview works because the text hasn't been in the database yet
I see... But once again, if the problem is in the database, why would the older posts not be affected?
This is pretty frustrating
Maybe unimportant, but actually the "example" plug-in writes perflectly the text I give it to him, no matter what accents I use...
It looks to me like the language files are in ISO-8859-1, whereas the database is encoded in UTF-8
That's possible... But in that case, why are the new posts also faulty? they should be encoded correctly, no?
Link?
Here it goes:
http://lunerouge.ochipepe.org/forum/index.php
Initially everything looks fine (lots of accented characters correctly encoded), but you can see for instance that instead of "Déconnexion", there is "D,connexion", and other similar mistakes. The worse is when you type new posts....
Ok, I had to migrate a french speaking punBB forum to a new server.
Everything is working fine, except for the character encoding. Certain characters (such as à, for instance), do not appear correctly, which completely mangles the text. This is true for the text in the menus (in french), and also in the texts I write.
This was not a problem in my previous server. Actually, all the posts made in that server are still encoded perfectly well. It's only the posts written in punBB on the new server that are mangled (and the menu's text).
Does anyone have a clue of what's going on, and how can I adress this? I don't understand why punBB was producing perfectly fine text, and now sputters so much garbage.
Thank's a lot, that was most helpfull
Ok, this is strange:
Before moving my forum between hosts, I tried to be a good housekeeper, and closed the forum for maintenance.
I then copied all the files, backed up the DB, and restored it in my new server.
When I went to check the forum I get a nice message:
"Maintenance
The forums are temporarily down for maintenance. Please try again in a few minutes.
/Administrator"
Well, considering I AM the admin, and I have no clue how to login, downtime could last more than a few minutes
Do you have a clue on how to recover access to the forum?
Pages 1
PunBB Forums → Posts by AlexS
Powered by PunBB, supported by Informer Technologies, Inc.
