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
Search found 9 matches
- 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
- 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:
For reasons of security, please backup phpbb_topics first.
Regards
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 '';
Regards
- 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
can you please post the error message that you get?
Reagrds
- 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
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
- 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
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
- 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
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
- 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 ...
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 ...
- 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
Regards
- 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 ...
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 ...