Took 1.1.0 down, my apologies...

[Dave A]

I'm sorry but I will be going for tonight, I'll be back tomorrow night!  Any problems E-mail me at [email protected]!  And I'll try and reply as soon as possible!

[Rpg Cyco]

Ok, I tried something different, I manually edited mysqlfix.sql and put my prefix on it and now I can view boards but I still get errors when I try to edit my profile, I can wait till the new release tomorrow though....
Thanks for all your help!

l8ter

Rpg Cyco

[Godai]

The not added column was a know problem, jeff probably was pushed to release by the great request on the board and he forgot to change something. No problem jeff, it happens to the best

P.S. for lamers i can only say: kiss our a*s*

[Webby]

With the few hints / tips (f.e. adding the table), I was able to get the whole board running.

So far no errors  

I guess this was the only problem, or not ?

By - the - way : you're doing a great job, Jeff !

There will always be people complaining, but hey, they are just losers anyway !

[Rpg Cyco]

Earlier on in this topic, DKADAVE said to do this:

Code Select Expand

This error can be fixed by adding (usertitle)TINYTEXT to the members table!

to fix this error:

Code Select Expand

2: Supplied argument is not a valid MySQL result resource
(/home/sites/site13/web/forums/Sources/Profile.php ln 40)

So I made a .sql file and put this in it:

Code Select Expand

ALTER TABLE yabbse_members ADD 'usertitle' TINYTEXT;

and it gave me this error when I added it with phpMyAdmin

Code Select Expand

Error
SQL-query :  

ALTER TABLE yabbse_members ADD 'usertitle' TINYTEXT

MySQL said:


You have an error in your SQL syntax near ''usertitle' TINYTEXT' at line 1

I am new to mySQL as of 10 hours ago! Can anyone help me?

l8ter

Rpg Cyco

[irbrian]

Hey Jeff, sorry you got flamed by some losers, man -- I think most of us are just really grateful to you guys for putting so much effort into this great product.

And I don't know if I'm the first one to say it or not -- but thanks for taking the update down. In other words, thanks for catching those mistakes, which I know as a programmer are very easy to make. It would have caused me all kinds of hassle if I'd downloaded it and installed it without making a backup (which of course I am still going to do, just like everyone else. Right guys?.... RIGHT?) Anyhow.. all you dev guys rock, Jeff, thanks again, and I'm sincerely looking forward to seeing the latest results of all your hard work.

[np]

Earlier on in this topic, DKADAVE said to do this:

Code Select Expand

This error can be fixed by adding (usertitle)TINYTEXT to the members table!

to fix this error:

Code Select Expand

2: Supplied argument is not a valid MySQL result resource
(/home/sites/site13/web/forums/Sources/Profile.php ln 40)

So I made a .sql file and put this in it:

Code Select Expand

ALTER TABLE yabbse_members ADD 'usertitle' TINYTEXT;

and it gave me this error when I added it with phpMyAdmin

Code Select Expand

Error
SQL-query :  

ALTER TABLE yabbse_members ADD 'usertitle' TINYTEXT

MySQL said:


You have an error in your SQL syntax near ''usertitle' TINYTEXT' at line 1

I am new to mySQL as of 10 hours ago! Can anyone help me?

ALTER TABLE yabbse_members ADD usertitle TINYTEXT;

[Jeff Lewis]

Ok, I'll re-examine what was missing (upgrade script, usertext field) and repackage.  Did anyone notice anything else missing?

[Godai]

Sincerely jeff, i don't notice a problem after the manual installation i did with you

[Webby]

I really don't know what else might be wrong.

It works for me !

[Koth]

Hey Jeff, sorry you got flamed by some losers, man -- I think most of us are just really grateful to you guys for putting so much effort into this great product.

And I don't know if I'm the first one to say it or not -- but thanks for taking the update down. In other words, thanks for catching those mistakes, which I know as a programmer are very easy to make. It would have caused me all kinds of hassle if I'd downloaded it and installed it without making a backup (which of course I am still going to do, just like everyone else. Right guys?.... RIGHT?) Anyhow.. all you dev guys rock, Jeff, thanks again, and I'm sincerely looking forward to seeing the latest results of all your hard work.

What he said, Ditto that.

[badguy]

One more problem, after I changed board pref. via admin page, file Settings.php got extra new line character \r\n that generated garbage output when index.php call Settings.php by includeonce function.

Solution: Save Admin.php as UNIX format

[Dave A]

If you use my mysqlfix.php

The coding in mysqlfix.sql is:

Code Select Expand

ALTER TABLE boards ADD `isAnnouncement` TINYINT DEFAULT '0' NOT NULL;
ALTER TABLE members ADD `usertext` TINYTEXT;

[Rpg Cyco]

ALTER TABLE yabbse_members ADD usertitle TINYTEXT;

Thanks np!

l8ter

Rpg Cyco