I just can't get this mod to work at all http://etern.mine.nu/uploadimg.php it results in a blank page. Any ideas? I have loaded the gd-library succesfully. I've download another mod also http://etern.mine.nu/gallery_upload.php (you're free to try) but when I upload a picture it's the picture isn't there. Hmm maybe I should use an .htaccess file...
1 2007-06-15 23:14
Re: Automatic Image Upload with Thumbnails (154 replies, posted in PunBB 1.2 modifications, plugins and integrations)
2 2006-05-21 18:12
Re: Unable to create topic... (11 replies, posted in PunBB 1.2 troubleshooting)
lol, that is 3 seperate queries
If you want to run them all at once, add a ; to the end of each
Otherwise, run them seperately
Thanks! I can now create topics again! Thanks! The only problem now is the poll plugin.
An error was encountered
File: f:\webserver\forum\hej\poll.php
Line: 265
PunBB reported: Unable to create poll
Database reported: Field 'voters' doesn't have a default value (Errno: 1364)
I tried to run the same command but I replaced the topics with polls like this:
alter table polls change question question varchar(255) not null default '';
alter table polls change yes yes varchar(30) not null default '';
alter table polls change no no varchar(30) not null default '';
but it the following message appeared:
Error
SQL query:
ALTER TABLE polls CHANGE question question varchar( 255 ) NOT NULL default '';
MySQL said:
#1054 - Unknown column 'question' in 'polls'
I guess the values yes yes and no no shouldn't be there, well it's probably completely different commands in this case
I want to thank you all for helping me!
EDIT: Tried this command:
alter table polls change votes votes varchar(255) not null default ''
but it didn't make any difference...
EDIT 2: I'm such a idiot, why didn't I ran 'voters'? I tried this line
alter table polls change voters voters varchar(255) not null default ''
And it worked.
Thanks for all the help!
3 2006-05-21 14:38
Re: Unable to create topic... (11 replies, posted in PunBB 1.2 troubleshooting)
Just topics without the ''
Hmm still doesn't seem to work, after I typed that in I got these results
Error
SQL query:
ALTER TABLE topics CHANGE question question varchar( 255 ) NOT NULL default '' ALTER TABLE topics CHANGE yes yes varchar( 30 ) NOT NULL default '' ALTER TABLE topics CHANGE no no varchar( 30 ) NOT NULL default ''
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alter table topics change yes yes varchar(30) not null default''
alter table to' at line 2
4 2006-05-21 11:57
Re: Unable to create topic... (11 replies, posted in PunBB 1.2 troubleshooting)
Where can I see my database prefix?
config.php
Ok, $db_prefix = ''; so it should be like this
alter table ''topics change question question varchar(255) not null default ''
alter table ''topics change yes yes varchar(30) not null default ''
alter table ''topics change no no varchar(30) not null default ''
When I run it I get the following message:
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''topics change question question varchar(255) not null default ''
alter table ' at line 1
5 2006-05-20 22:08
Re: Unable to create topic... (11 replies, posted in PunBB 1.2 troubleshooting)
EasyPoll 1.1.3
Run the following SQL queries (replace prefix with your database prefix)alter table prefixtopics change question question varchar(255) not null default '' alter table prefixtopics change yes yes varchar(30) not null default '' alter table prefixtopics change no no varchar(30) not null default ''
I think I left my prefix values blank during the punbb installation. Where can I see my database prefix? I'm administrating MySQL with phpmyadmin and I tried to run those commands with the database name in front of topics (I replaced the prefix as you said) but with no success. Well I guess I have to do a little bit of a research tomorrow
6 2006-05-20 12:36
Re: Unable to create topic... (11 replies, posted in PunBB 1.2 troubleshooting)
What mod did you install that adds question to topics?
The only mod I have tried to install is the Easy Poll 1.3.
File: f:\webserver\forum\hej\poll.php
Line: 262
PunBB reported: Unable to create topic
Database reported: Field 'yes' doesn't have a default value (Errno: 1364)
It seems like it's the php file that is incorrect or is it the mysql server?
7 2006-05-19 13:24
Re: Unable to create topic... (11 replies, posted in PunBB 1.2 troubleshooting)
What values should I type in? I have opened the file post.php and found the line but I really don't know what to do?
This is line 288 in post.php
$db->query('INSERT INTO '.$db->prefix.'topics (poster, subject, posted, last_post, last_poster, forum_id) VALUES(\''.$db->escape($username).'\', \''.$db->escape($subject).'\', '.$now.', '.$now.', \''.$db->escape($username).'\', '.$fid.')') or error('Unable to create topic', __FILE__, __LINE__, $db->error());
8 2006-05-11 14:05
Topic: Unable to create topic... (11 replies, posted in PunBB 1.2 troubleshooting)
An error was encountered
File: f:\webserver\webdesign\forum\post.php
Line: 288
PunBB reported: Unable to create topic
Database reported: Field 'question' doesn't have a default value (Errno: 1364)
I think it has something to do with the database. I use phpmyadmin to access the database, I have marked all tables and repaired them but there were no change at all
I would appreciate if someone could help me out I have tried to search but didn't find anything.
9 2006-05-10 20:48
Topic: Problem att göra ny tråd... (0 replies, posted in Archive)
An error was encountered
File: f:\webserver\webdesign\forum\post.php
Line: 288
PunBB reported: Unable to create topic
Database reported: Field 'question' doesn't have a default value (Errno: 1364)
Administrerar med phpmyadmin, är färsking med databaser och php
Har testat markera alla mina tabeller och reparerat dem, tagit bort php filerna i cache mappen och startat om apache servern.
Någon som har en lösning?
Tack på förhand!