1

(2 replies, posted in PunBB 1.2 troubleshooting)

According to phpinfo - 20M

For some strange reason, no one can upload their avatar in their account panel.  I even tried myself through the admin panel and I get the following error message:

"The selected file was too large to upload. The server didn't allow the upload."

The file is 2kb in size and the default 10k limit is set - any ideas???  This just happened all of a sudden.

Update:  I manually uploaded to the avatars folder via ftp - renaming the image to the id number of the forum member - it shows up in their profile so I'm not sure what's going on...

TIA,

dariottolo wrote:
elbekko wrote:

I'd just put it in the announcements part.

In this case, it seems like I can not use a different banner for each sub-forum, right?

One more question: how can I change from announcement to advertising?

Thanks for your help.

Dario

Insert your advertising code where you would place the announcement - That is what I did for the top of the page for my forums - take a look at http://www.uwdv.com/forums

basically - for the sub forums, there is an area for the description of the forums - input any html code in that box and it will render out accordingly.  SInce I run phpadnews, I generate the necessary code for the specific banner ad that is registered with the ad server - it generates the necessary code for insertion into a page.  Copy and paste the code - Pretty straight forward actually.

Oh the joys of ever changing web technology wink

I know - That was what I couldn't figure out...  It imported fine locally, but it didn't like it at all on the remote server - might be something particular to their server - who knows.. All I know is I'm glad this nightmare is over...

Ok - I FINALLY figured out what was throwing the errors when trying to import into MySQL5 - it appears that any reference to "DEFAULT CHARSET=latin1" needs to be removed from the MySQL 4.1.x data dump if bringing the dump into MySQL 5

HTH anyone who runs into similar issues.

Ok - now I'm totally confused...  I wonder why it works for you but not me?

I was able to bring the database dump fine onto my local version of MySQL 5 running on my Windows based workstation.  I then dump the database back out and try to upload to the remote server - then I get the error message.

Is there anything specific I should be doing regarding the settings for the export of the database to make sure it will import on the remote server???

I'm about to give up - I have lost 2 days worth of work because I can't get this issue resolved.... sad

ok - So I edited out the comments at the top and now I am getting the error message saying line 9 is the culprit:

CREATE TABLE `forums_bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `ip` varchar(255) default NULL,
  `email` varchar(50) default NULL,
  `message` varchar(255) default NULL,
  `expire` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

No other code has been deleted excpet for the rest of the SQL dump below this - I figure if this is the first one, it will be easier to trouble shoot any others thrown after this

Well, the saga continues - it seems even with getting the database imported locally on the latest version of MySQL5 for Windows, the SQL dump and import to the web hosting server is still throwing the same #1064 Error in Syntax message - Now I know why I hate this kind of thing so much..

Here's what I am getting when trying to import the SQL dump to the host provider:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 21, 2006 at 08:39 AM
-- Server version: 5.0.18
-- PHP Version: 5.1.2
--
-- Database: `uwdv_forums`
--
-- --------------------------------------------------------
--
-- Table structure for table `forums_bans`
--
CREATE TABLE `forums_bans` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`username` varchar( 200 ) default NULL ,
`ip` varchar( 255 ) default NULL ,
`email` varchar( 50 ) default NULL ,
`message` varchar( 255 ) default NULL ,
`expire` int( 10 ) unsigned default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1

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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 27

I'm stumped as to what the Syntax error is - I can post a full SQL data dump but it is over 900K in size...

I actually resolved the issue - who would have known that an SQL data dump from MySQL 4.1.9 would have a one space syntax error on line 1 that MySQL 5.0.3 didn't like???

I am running into a major challenge here and I need someones help really bad.

My previous host provider more or less has just become too flaky and I needed to transition over to a new host provider - unfortunately, they have upgraded all ther MySQL databases to version 5 and I can't get my SQL data dump to populate the database fields.

I am getting the following Error every time I export it out.

This happens for each dtabase table:

"#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 '"forums_categories" (
  "id" int(10) unsigned NOT NULL,
  "cat_ "

I get something similar with each database table - What can I do???  I'm not a MYSQL guru.

sad

I kind of figured it out - can add html code in the sub forum description - am using phpadnew as ad server - works ok..

I actually answered my own question - roll

I am wondering how I can insert some type of a banner ad on the main page for each forum section?  I have had a couple of inquiries about sponsoring a section of my websites forums - have like a 120x40 banner ad that would show the companies logo.

Am I making sense???  Is this even possible???

TIA,

16

(29 replies, posted in PunBB 1.2 troubleshooting)

yup - Limbo - it reminds me of punbb - ligtweight and fast - running on MySQL for improved performance. smile

17

(29 replies, posted in PunBB 1.2 troubleshooting)

Thanks Paul!  You saved my bacon.. wink

That's what I get for being up since 3:30 in the morning - I looked at that piece of code for too long and didn't see something as simple as a closing bracket missing in a style sheet - and I use TopStyle as my CSS editor..

All is well, and I'm headed to bed.. Thanks again!

18

(29 replies, posted in PunBB 1.2 troubleshooting)

As a followup - The only changes made to PunBB have been to the Oxygen.css style sheet at the following section:

original
/****************************************************************/
/* 5. VERTICAL AND PAGE SPACING */
/****************************************************************/

/* 5.1 Page margins */

HTML, BODY {MARGIN: 0; PADDING: 0}
#punwrap {margin:12px 20px}

modified:

/****************************************************************/
/* 5. VERTICAL AND PAGE SPACING */
/****************************************************************/

/* 5.1 Page margins */

HTML, BODY {MARGIN: 0; PADDING: 0}
#punwrap {margin:1px 1px}

body {
    background-color: #0066cc;

And adding a table around the forum code in the main.tpl page to allow the page to look simiar to the rest of the site.

I have even reuploaded unmodified cascading style sheets and the default templates - and I still do not see the icons so I know it isn't something I did.

Any ideas why my icons at the left disappear with IE and firefox, but render fine in Opera???

I'm so close to going back to phpbb it isn't funny...  hmm

19

(29 replies, posted in PunBB 1.2 troubleshooting)

then why does it work with Opera 8.5???  AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!!! mad

It looks perfect with Opera...

20

(29 replies, posted in PunBB 1.2 troubleshooting)

Ok - Well, been up since 3:30 this morning and finally got the site to go live - and yes, I went back to PunBB after a little more research.. wink

You can see it at http://www.uwdv.com/forum/

I do have an issue I can't seem to resolve - my new post notifications Icon isn't showing in IE6 but is working fine with Opera and Firefox and I can't figure out why. (GAWD I hate IE!)

I went back to the stock install and made sure it was running by itself before any modifications.

Any ideas???

21

(29 replies, posted in PunBB 1.2 troubleshooting)

Rickard wrote:
bluedigitalmedia wrote:

I was quite happy with punbb - until I had to upgrade and it totally FUBAR my layout.

The version you were running was a year and half old. That's an eternity. Expecting a current release to be completely backwards compatible with any hacks and styles from the old version is not realistic.

Thanks Rickard - btw - does the converter work with the current version of phpbb to punbb?  I'm all about using punbb again because of it's speed..

Cliff

22

(29 replies, posted in PunBB 1.2 troubleshooting)

Notch wrote:
bluedigitalmedia wrote:

I finally gave up and moved the forums to phpbb.. I couldn't afford to take any more time out of my day to work on this..

You just went from secure to massively UNSECURE... roll

The issue here is that I had a properly working version of punbb - but due to it's version number - it had security issues - although I don't know what they were.

You state that now I'm using phpBB it is not secure - unless one can prove as such, it is speculation.  I know phpBB has had security issues in the past, but my research indicates that the developers are taking a more active role in addressing those issues.  I was quite happy with punbb - until I had to upgrade and it totally FUBAR my layout.

Also - my host provider supports phpBB via Fantastico in my cPanel so that I will know when a new update is available - that was something I didn't have with punbb.

I appreciate your POV on this issue - believe me - I would rather have kept with punbb, but it was more or less a business decision - my site is a commercial website and I need to make sure I can maintain regular security updates - phpBB offers me that currently.

23

(29 replies, posted in PunBB 1.2 troubleshooting)

I finally gave up and moved the forums to phpbb.. I couldn't afford to take any more time out of my day to work on this..

24

(29 replies, posted in PunBB 1.2 troubleshooting)

As much as I have researched Forum apps, yes, PunBB is really a very efficient and what appears to be - secure - forum app.

I am trying to give it my best shot right now but am stumped on this issue.

If you visit the current updated forum at http://www.uwdv.com/forums - I need a question answered and I cant seem to fix the issue - My topics seem to have quite a bit of space between the lines and I am banging my head as to how to move the line spcing in closer - I have looked at the style sheets but they give no answer to how to make the line spacing a normal default value - any ideas???

25

(29 replies, posted in PunBB 1.2 troubleshooting)

Well, after much hair pulling - I have some semblance of a forums working - although I had to more or less remove ALL of my custom formatting due to a drastic change in the way the code is implmented.

sigh hmm