Help - Search - Members - Calendar
Full Version: Plesk And VBulletin
The Planet Forums > Control Panels > Plesk
Creeper
I have set up vbulletin on the websites on my server...

Now the setings for apache and vbulletin seem to be ok for uploading files...

If I try to upload a 1 meg file in vbulletin I used to get a apache error stating it was to big or wrong file type.. So I edited the my.cnf to look like this..

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=350
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

Now this cured the apache problem... now I am left with an sql error...

Now this error only occures again when uploading a file over 1 meg and file under 1 meg uploads fine...

Database error in vBulletin 2.3.2: Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,filedata,visible) VALUES (NULL,7,1067872155,'outlaw.zip','PK

The sites work fine on the other server which is using cpanel so were wondering if there is something in Plesk were missing?

Thanks
mahiraminc
ftp the file to your server and run mysql import command on your shell

mysql -u username -p password myforum < myforum_backup.sql

replace username, passowrd accordingly

replace myforum by the database name your importing data to

replace myforum_backup.sql by the dump file name
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.