Classic self-hosted technical help

4,394 topics in this forum

1. 

   unable to resotre backup

   June 4, 2009 by Prajyot2007

   • 1 reply
   • 213 views

   when i trying to install database backup (which is created from admin area) i am getting following error 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 'where varchar(255) NOT NULL, summary text NOT NULL, fid int(11) NOT NULL, ' at line 27 MySQL says: CREATE TABLE ibf_ahreports ( id int(10) NOT NULL auto_increment, whoreported varchar(255) NOT NULL, whoupdated varchar(255) NOT NULL, reportmsg text NOT NULL, tid int(11) NOT NULL, pid int(11) NOT NULL, comments int(11) NOT NULL, severity text NOT NULL, status varchar(255) NOT NULL, title varchar(255) NOT NULL, reportdate varchar(255) N…

   

   Last reply by beeman, June 5, 2009
2. 

   Mysql backup dump too large for re-installing !

   April 7, 2009 by chasz

   • 17 replies
   • 543 views

   Mysql dump too large for re-installing !! i dumped my client's database into a file, thinking all i had to do was rerun the queries and we re away !! But the mysql server keeps timing out before it gets completed !! Does anyone know how to do this?? i tried the mysql tool that came along with it, and a couple of other commercial ones and none of them can keep the server alive long enough to complete the task.

   

   Last reply by ehren., May 29, 2009
3. 

   Matching IPs

   April 20, 2009 by Shef

   • 1 reply
   • 195 views

   Technically, there has been a volume of people getting IP banned on my site due to breaking our rules. And when I checked "Manage Validating" then manually clicked people's IP's, it matched to the banned person. Is there anyway when I go on boards, and someone who's banned and registers a new account, I can get a alert or notification that can be sent to me about it? Because this issue is getting worse, and I need to get rid of the people immediately. Thank you.

   

   Last reply by Robulosity2, May 19, 2009
4. 

   Recover Deleted Forum!

   May 18, 2009 by pavo

   • 1 reply
   • 449 views

   I inadvertently deleted an entire forum containing about 50 topics and 500+ postings. Is the content still in a file somewhere? Is there a data recovery mechanism in the Admin Panel? Thnaks. ^^

   

   Last reply by Michael, May 19, 2009
5. 

   Slow forum

   November 23, 2008 by DiaVoLo

   • 10 replies
   • 684 views

   Hi, I need some help optimalize my forum I think, its running slow when creating new topics and posts. I have a pretty fast server: CPU: Quad Core 2.13 ghz RAM: 2048mb When I look at system usage, its not so high either. I tried to optimize my posts table, who is now 1gb large. I have 500-1000 post each day. Anyone have other tips to optimize for better performance?

   

   Last reply by Alex K., May 7, 2009
6. 

   high cpu usage

   April 22, 2009 by Guest Grey F0x

   • 6 replies
   • 491 views

   hello i have a vps with 550 ram and 8core cpu with 1,5ghz dedicated cpu for every core and i have a high cpu usage here are some logs the id is 99% my forum has 1300 members and 7000 posts. any suggestion? thank you

   

   Last reply by rct2·com, April 24, 2009
7. 

   New VPS and high CPU usage 1 2

   January 24, 2009 by Guest markopolo2002

   • 33 replies
   • 1.2k views

   Hi guys, wondering if any can help steer me in the right direction here. We've just moved from shared hosting across to VPS hosting and have 6 sites on the same VPS. They're all PHP and other than my main site they aren't generating much traffic as they are still in eary days. My main site however is generating decent traffic although since we moved to the VPS I've definately noticed a decrease in the sites performance. Pages are sluggish and dare I say it shared hosting performed better!. If anyone can offer any advice I'd really appreciate it :) Linux CentOS-5 2048MB RAM (Burstable 4096MB) 3.8Ghz CPU MYSQL 5.0.67-community PHP: 5.2.8 (apache2handler) m…

   

   Last reply by Twista09, April 19, 2009
8. 

   IP TSL 1.1 (Top Site List) error: Unknown column 's.id' in 'on clause'

   April 15, 2009 by Guest RTM

   • 1 reply
   • 272 views

   We recently moved to MySQL 5 and PHP 5... after that, our IPB 2.3.6 forum works fine, but trying to access the links area (powered by the legacy Invision TSL product) top site list results in this error: Unknown column 's.id' in 'on clause' Error: Error executing query The software returned the following error: Unknown column 's.id' in 'on clause' Query Executed: SELECT s.*,COUNT(DISTINCT c.id) as comment_count, AVG(v.value) as rating,COUNT(DISTINCT v.id) as num_votes, IF( COUNT(DISTINCT v.id) , 2 * COUNT(DISTINCT v.id) * (AVG(v.value)-3),0) + (1 * in_count) + (1 * out_count) + (1 * hit_count) as combined_rating, COUNT(DISTINCT me.id) as already_voted FROM ts…

   

   Last reply by RTM, April 17, 2009
9. 

   vps best performance

   April 9, 2009 by Guest Grey F0x

   • 3 replies
   • 290 views

   hello. i bought a vps with 512 up to 550 ram for my forums. i want you to suggest me the best performance for my forum. my server is running debian.my forum has 1200 members and 6,574 posts but it is growing fast. can you tell me the best values for my php.ini and my.cnf? thank you

   

   Last reply by stoo2000, April 10, 2009
10. 

    Re-installing Sphinx for IPB

    November 4, 2008 by Guest SecondSight

    • 1 reply
    • 350 views

    Hello ! I've just had my board transfered and now my search engine "Sphinx" no longer works. I get an error : Erreur Sphinx : connection to localhost:3312 failed I told myself I had to restart it ? So I tried this : /usr/local/bin/searchd --config /usr/local/etc/sphinx_ipb.conf But it says : -bash: /usr/local/bin/searchd: no such file or directory. What should I do now ? Re-install everything ? Thank you ! :)

    

    Last reply by ssslippy, April 5, 2009
11. 

    blank page

    April 1, 2009 by Guest Grey F0x

    • 1 reply
    • 431 views

    hello I just moved to a new vps with apache php and mysql. i have put the files in public_html and i have change the password for the mysql in conf_global so i can work my forum. but when i am going to my index.php i am getting a blank page but my admiCP is working just fine. please help meee

    

    Last reply by Martin A., April 1, 2009
12. 

    Mysql Error - Error 1064 (42000) At Line 13332:

    October 2, 2007 by Guest Bobsuch

    • 4 replies
    • 600 views

    Hi, I'm getting the follow error when I try to restore a Mysql ERROR 1064 (42000) at line 13332: 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 'INSERT INTO `ibf_member_extra` (`id`,`notes`,`links`,`bio`,`ta_size`,`photo_type' at line 591 How can I solve this? I've got 5 backups, all of them with a difference of 1 day, and they're all giving the same error Thanks!

    

    Last reply by RTM, March 31, 2009
13. 

    Spider/search Bots stopped visiting

    March 24, 2009 by Guest rct2·com

    • 3 replies
    • 324 views

    I took a couple of domains down for around 24 hours while I moved them to a new server. So as a result, the IP address has changed. I had set up DNS earlier in the week so that the new IP should propagate in 30 minutes. Less than 24 hours after I brought the sites back up, one board has had a record of almost 3000 different visitors in a 60 minute interval. Almost 2800 of them were Guests. Another 24 hours later and the numbers are still running consistently above 1500 in 60 minutes. But NONE of them are spiders/bots. Not a single search bot has visited the domain since 21st March just before I shut it down. Does it NORMALLY take the search bots this long to revis…

    

    Last reply by rct2·com, March 25, 2009
14. 

    Optimize Mysql

    March 24, 2009 by Guest WoLeRiNe`

    • 1 reply
    • 360 views

    I have server Intel

    

    Last reply by stoo2000, March 24, 2009
15. 

    Help modifying max_execution_time on localhost

    March 11, 2009 by Guest FrostedPopTart

    • 11 replies
    • 395 views

    Before you ask, yes I modified php.ini, my.cnf, and httpd.conf already; along with putting a .htaccess in my phpmyadmin directory and even going so far as to add a line in the affected file(s) to do an ini_set and trying to change it that way, all to no avail. The problem is that I have set up Wamp Server on my computer for testing purposes, and I am trying to import a rather small (about 10.5 mb) database. The problem may be that it has loads of rows (almost 72,000; to be exact). So what should I do, since all I am getting is: Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin3.1.1\libraries\dbi\mysqli.dbi.lib.php on line 165 ?…

    

    Last reply by AndyF, March 14, 2009
16. 

    Error while importing Database

    March 11, 2009 by Guest SRS

    • 2 replies
    • 277 views

    When im importing database using bigdump im getting error Error at the line 3004: SET character_set_client = @saved_cs_client; Query: SET character_set_client = @saved_cs_client; MySQL: Variable 'character_set_client' can't be set to the value of 'NULL' can someone suggest me how to correct this error

    

    Last reply by SRS, March 11, 2009
17. 

    Transferring servers

    January 10, 2009 by Guest Philiwily

    • 8 replies
    • 682 views

    I'm in the process of transferring servers, and importing my sql database is giving me issues. It's 135mb, 25mb gzipped. When I try to import it in phpmyadmin, I have "Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions" ckecked off. So, it will do a couple of tables, then stop. Then I have to start it again. If I uncheck it, Firefox just times out after a little bit and I have to start from the beginning. Is there any easier way to do this? I've transferred servers before and I've never had this problem.

    

    Last reply by rct2·com, March 9, 2009
18. 

    Do .js files query the database?

    January 21, 2009 by Guest fishfood

    • 3 replies
    • 251 views

    Hi there, I've got major issues with my hosting provider. I run a moderately popular website with several thousand registered members, but only ever about 10-20 users online at a time (although there are normally a similar number of guests too). They say that the site has outgrown the resellers account I currently use and I need to move up to a dedicated server. I disagree with them and think they're just trying to get more money off me. Anyway - after lengthy discussion they reckon that this is the list of files which are being most problematic in terms of causing CPU overload: Looking at the files I see a lot of javascipt files, a gif, a css and not a a co…

    

    Last reply by rct2·com, March 2, 2009
19. 

    webhost upgrade to php5

    February 23, 2009 by Guest bern5

    • 5 replies
    • 249 views

    Im asking my host to upgrade from php4 to php5 so i can run some other software. what do i have to do before this? anything? will my ipb still work without any adjustment? thx in adv.

    

    Last reply by rct2·com, February 28, 2009
20. 

    Error messages in e-mail sent by CPanel

    January 24, 2009 by Guest SecondSight

    • 3 replies
    • 284 views

    Hello ! :) I'm making a backup every day and CPanel sends me an e-mail. Today, in the e-mail, I found this line : So I'm wondering why I get this "permission denied" error today (and not before). I've had a look at the two files inside my uploads directory. I noticed that for the files, the owner and group could be : root root or myaccount myaccount The two files, which had been uploaded on the 19th of June 2004, are chmoded 444 (the other files are all chmoded 777, 755 or 644) and for both files owner and group are : root In another directory I used for backing the files, I see that the files are chmoded 777 and the user isn't root but myaccount…

    

    Last reply by stoo2000, January 25, 2009
21. 

    Force Ipb To Retrieve Images Off From Server #2

    August 8, 2007 by Guest Bobsuch

    • 4 replies
    • 656 views

    Hi, I've read about how retrieving your images from another server may take some load off your server. - Is that even true? Is this possible? Is this even worth the effort?

    

    Last reply by MolteniMike, January 23, 2009
22. 

    Domain?

    January 8, 2009 by Guest DolphinsFan92

    • 1 reply
    • 575 views

    Hey, I just bought a Domain on Godaddy.com An I went to the name servers and changed them to NS1.IPSLINK.COM NS2.IPSLINK.COM Which is what I think i was supposed to do? Anyways it had been about 4 days and still no domain change to my site. I am using the http://MYLINK.invisionzone.com/ Right now. So is there an issue or what? not sure. Also I have a basic ISP hosting plan that i am trying to get this domain on if that helps at all. Thanks, Josh

    

    Last reply by AndyF, January 8, 2009
23. 

    Too many connections

    December 22, 2008 by Guest BognorRidges

    • 5 replies
    • 586 views

    Hello I have my forum on a powerfull dedicated server.. The last 2 Days i get an IPB Driver error.This is some of my errors. The 3 xxx are all from the same forum. =================================================== Date: Mon, 22 Dec 2008 11:05:17 +0000 Error Number: 1040 Error: Too many connections IP Address: 80.134.61.10 Page: /myforum/index.php?showforum=xxx =================================================== Date: Mon, 22 Dec 2008 11:05:18 +0000 Error Number: 1040 Error: Too many connections IP Address: 80.134.61.10 Page: /myforum/index.php?showforum=xxx =================================================== Date: Mon, 22 Dec 2008 11:05:1…

    

    Last reply by Bono, December 23, 2008
24. 

    eaccelerator

    December 23, 2008 by Guest matma4u.pl

    • 1 reply
    • 413 views

    I installed eaccelerator. Tell me $INFO['use_eaccelerator'] = 1; is good or $INFO['use_eaccelerator'] = '1'; in conf_global.php My configuration: eAccelerator support enabled Version 0.9.5.3 Caching Enabled true Optimizer Enabled false Memory Size 33,554,396 Bytes Memory Available 23,813,344 Bytes Memory Allocated 9,741,052 Bytes Cached Scripts 92 Removed Scripts 0 Cached Keys 0 It is good?

    

    Last reply by matma4u.pl, December 23, 2008
25. 

    Tweaking a server for IPB - How ?

    December 15, 2008 by Guest SecondSight

    • 2 replies
    • 449 views

    Hello ! :) I'm having a few high server loads on my new server and I don't understand why... My old server was : 8 processors Intel® Xeon® CPU E5345 @ 2.33GHz speed: 2334.683 MHz cache size: 4096 KB With 6 Gb RAM. My new server is : 8 processors Intel® Xeon® CPU E5430 @ 2.66GHz speed: 2660.194 MHz cache size: 6144 KB With 12 Gb RAM I suppose my new server is more powerful... I also have eaccelerator installed. But, if my old server was working well with 800/1200 users online, this new server I have now gets high server loads with only 450 users online... So I don't understand. So I wonder : is there a special way of configuring the server for IPB ? …

    

    Last reply by SecondSight, December 21, 2008