Admin pages variables don't line up, Boxes-Windows

[ivansgarage]

Tryed to install Feedposter

SQL logic error or missing database
near "NOT": syntax error
File: /home/content/i/v/a/ivanb/html/forum/Packages/temp/FeedPostersql2.php
Line: 33

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.3, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.

And Now...............I got hundreds of hours setting this forum up.

All of the admin settings...

All of the variable message windows don't line up with check boxes

were the smf logo (on top above search) was I had text in that box and it all carriage return  vertically instead of a horizontal

What file would control this action???

Can I just ftp the original file to take care of this problem???

ivanbennett dot com slash forum

[Storman™]

Fraid I don't have a clue what you are talking about. Was that a question ?

Could you please rephrase the question and give specific details about what your issue is.

[kat]

I think he's trying to install this:

http://custom.simplemachines.org/mods/index.php?mod=624

In which case, you need to post in the mod's support topic, ivansgarage.

http://www.simplemachines.org/community/index.php?topic=141776.msg903834#msg903834

Might be worth deleting everything in that "temp" directory and trying again, though.

By the way... You DID backup, before you tried to install it...

Didn't you?

[ivansgarage]

Here is some pics of my screens.

[kat]

Assuming that you didn't backup, before installing the mod (Which is a bit daft, it has to be said), you might want to try this:

http://www.simplemachines.org/community/index.php?topic=400356.0

[ivansgarage]

Went way back on the backups, still no change.
Guess its time for a upgrade.
Any other ideas.

If i upgrade will it fix this database problem.
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.3, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.

Ivan    What is with this capitv,  I have 61 year old eyeballs.

[Storman™]

Went way back on the backups, still no change.

How did you revert to an older backup ?  Why I ask is that in order to answer the question "If i upgrade will it fix this database problem." it would be good to know exactly where you are at the moment and what you've done.

I assume you've got mods installed as well, also whats all those ads down the side of your forum ? Difficult to see from the pics but they see to overlap the main forum at times ?

[ivansgarage]

Went way back on the backups, still no change.

How did you revert to an older backup ?  Why I ask is that in order to answer the question "If i upgrade will it fix this database problem." it would be good to know exactly where you are at the moment and what you've done.

I assume you've got mods installed as well, also whats all those ads down the side of your forum ? Difficult to see from the pics but they see to overlap the main forum at times ?

In the packages backup  thats where i got my backups from.
I only have one mod installed the banner ads.
if you are refering to the pics above and adds they look better live.
http://ivanbennett.com/forum [nofollow]

Ivan

[Antechinus]

Are you using an older version of Internet Explorer? If you are using IE7, or perhaps IE8 in compatability mode, you'll probably get the misalignment shown in your shots.

[ivansgarage]

no  Ie9  and goog crome  the first pic with the test test test
is not a misalignment...

[ivansgarage]

I thought i would try the upgrade.   FAILED
did i loose my forum??

Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!

Executing: "Adding new indexes to attachments table." (17 of 25)

Database Updates Complete! Click Continue to Proceed. Adding search ability to custom fields...done
Adding new custom fields columns...done
Fixing default value for the "show_profile" column...done
Fixing default value for the "show_profile" column...done
Creating spider table...done
Inserting the search engines...done
Removing a spider...done
Creating spider hit tracking table...done
Creating spider statistic table...done
Enable cache if upgrading from 2.0 beta 1 and lower..done
Adding advanced password brute force protection to "members" table...done
Ensuring forum width setting present...done
Adding weekly maintenance task...done
Setting the birthday email template if not set...done
Adding pruning option...done
Adding type to mail queue...done
Adding multiple attachment path functionality...done
Adding file hash...done
Changing field_options column to a larger field type...done
Adding reset poll timestamp and guest voters counter...done
Fixing guest voter tallys on existing polls...done
Adding restore from recycle feature...done
Changing 'aim' to varchar to allow using email...done
Changing event title column to a larger field type...done
Changing holiday title column to a larger field type...done
Changing URL to SMF package server...done
Adding index member_started...done
Adding index last_message_sticky...done
Adding index board_news...done
Adding index on total_time_logged_in...done
Adding index on id_theme...done
Adding index on real_name...done
Adding index id_member_msg...done
Adding index current_topic...done
Adding index related_ip...done
Adding index on attachment_type...done
failed
!!Error!

Error retrieving information on step: Adding index on attachment_type... (Item: 71)

[kat]

Which versions are you upgrading to/from and how are you doing it?

did i loose my forum?? (sic)

Depends if you backed-up, first.

[ivansgarage]

Yes got backup

version 2.0.3   to  2.0.3 upgrading database

[kat]

version 2.0.3   to  2.0.3 upgrading database

You're upgrading from 2.0.3 to 2.0.3?

Typo, perhaps?

[ivansgarage]

That is correct  2.0.3  to 2.0.3 so i can upgrade the database was at 2.0.2

I used ftp and overwrite all files.

[Arantor]

Then you're at 2.0.3 and you should ignore the error message because it's wrong.

[kat]

It's what some have called a bug in SMF, that.

[Arantor]

Yup, it's a bug because the upgraders never fix it. To update it, they just have to go into the database, to smf_settings, and find the entry smfVersion, and update the version number there.

[ivansgarage]

So what do you recommend I do know..

[Arantor]

I recommend you stop doing what you think you need to do because there's no upgrading required at all.

[ivansgarage]

How about my first post  I have had this problem eversince the update.

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.3, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.

Then the menus problem..

[Arantor]

-sigh- Ignore that message, it's wrong. The Feed Poster mod has a bug in it, the author needs to fix it.

[ivansgarage]

Here is some pics of my screens.

Ok guys.  I did the upgrade 2.0.3 to same  hopeing this would fix my menu
screens problem but still the same.  On my computer I unziped the upgrade
then ftp all new files (with overwrite) to my forum folders, to my amazement
still got the same screens as displyed in pics.

So my thought is were can i find out what php or css file would control
something like this?  It looks like variable setting boxes are covering other
boxes... reminds me of a missing carriage return or tab...

[Storman™]

If the only change (mod) you've made is to add those adverts then I suspect there lies the issue. Otherwise it should line up just fine.

[ivansgarage]

If the only change (mod) you've made is to add those adverts then I suspect there lies the issue. Otherwise it should line up just fine.

Could you explain more?  advertisments everything was fine after adverts.

Is there a list of files from the programers what each file does.

[Storman™]

Could you explain more?

My point was that if the only change you've made was to add the advertisements mod then the issue must lie there. Unless you've made other adjustments as well then it simply should work.

[ivansgarage]

Well here is the conclusion..

Since I tryed everything else I thougt I would try..
I uninstall the advertizement, and the screens was back to normal.
So just for sh_ts and giggles I put it back.  Still ok

Thanks Guys for your support and time.

http://ivanbennett.com/forum [nofollow]

Ivan