Search found 9 matches

by fornit
Fri Feb 06, 2009 2:54 pm
Forum: phpBB 3.0.x Support
Topic: 'topic_last_post_subject' sql error on upgrade to 3.04
Replies: 8
Views: 13017

Re: 'topic_last_post_subject' sql error on upgrade to 3.04

That error usually comes up if you try to set a default for a field which has the type "text", "mediumtext" or so.

In my installation (3.0.4) that fied (i.e. topic_last_post_subject) has the type varchar(255). What's the field type in your table?

You can see that in phpmyadmin.

Regards
by fornit
Thu Feb 05, 2009 12:18 pm
Forum: phpBB 3.0.x Support
Topic: 'topic_last_post_subject' sql error on upgrade to 3.04
Replies: 8
Views: 13017

Re: 'topic_last_post_subject' sql error on upgrade to 3.04

Hi,

obviously it's missing the default value on that column. You can set that as follows:

Code: Select all

ALTER TABLE `phpbb_topics` ALTER `topic_last_post_subject` SET DEFAULT '';
For reasons of security, please backup phpbb_topics first.

Regards
by fornit
Wed Feb 04, 2009 9:51 pm
Forum: phpBB 3.0.x Support
Topic: Error 500 during convertion
Replies: 7
Views: 10315

Re: Error 500 during convertion

Hi,

can you please post the error message that you get?

Reagrds
by fornit
Wed Feb 04, 2009 9:21 pm
Forum: phpBB 3.0.x Support
Topic: New forum caching
Replies: 3
Views: 3981

Re: New forum caching

Hi,

sounds like a permission prob?!

Permissions are not cached as a file. There's a field named user_permissions in phpbb_users. In that field permissions are cached in form of a bitfield.

Regards
by fornit
Wed Feb 04, 2009 8:28 pm
Forum: phpBB 3.0.x Support
Topic: Math equations (with latex)
Replies: 9
Views: 13421

Re: Math equations (with latex)

Hi,

obviously it's a PERL script. You need that mimetex.cgi and you need access to your cgi-bin directory, e.g. to the location where PERL scripts can be executed.

But I'm not sure whether every provider will give you the access you need.

Regards
by fornit
Wed Feb 04, 2009 8:20 pm
Forum: phpBB 3.0.x Support
Topic: Backup Attachments
Replies: 5
Views: 4956

Re: Backup Attachments

Hi,

if you have a huge amount of attachments and SSH access it's best to tar them. Otherwise download will take a very long time.

To do so, you can eg. move to phpBB root dir via SSH and enter the following command:
tar -cvf files.tar files

Regards
by fornit
Wed Feb 04, 2009 6:33 pm
Forum: phpBB 3.0.x Support
Topic: Math equations (with latex)
Replies: 9
Views: 13421

Re: Math equations (with latex)

To be honest I don't understand the question because the document you've linked at contains the solution ;)

If you're using phpBB3, then no mod is even needed. Just click Postings from the Administrator Control Panel, and add the custom BBCode [tex]{TEXT}[/tex] with the HTML replacement <img src ...
by fornit
Wed Feb 04, 2009 5:44 pm
Forum: phpBB 3.0.x Support
Topic: Can we find members by emails?
Replies: 3
Views: 3548

Re: Can we find members by emails?

If you use standard settings then users can't register again with the same E-Mail ;) That's valid for banned users, too.

Regards
by fornit
Wed Feb 04, 2009 5:23 pm
Forum: phpBB 3.0.x Support
Topic: Error 500 during convertion
Replies: 7
Views: 10315

Re: Error 500 during convertion

Hi,

I guess that the 500 is simply caused by a timeout.

But don't waste your time in the waiting loop of 1und1 support - they will never change any of their php.ini-settings because you have probs with your conversion.

What you can try:
- Optimize all database tables from your old forum ...