I'm going crazy

[Nederland]

Okay, i tried to upgrade my yabb se forum so SMF, Then i needed to update the yabb SE that didn't work so after 6 houwers i tried to get my old forum back. This worked to a point.

My msqel database gives this error and i think it is the reason for many errors on my page.

SELECT * FROM `phpbb_posts_text` WHERE 1

These kind of error i got.

2: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
(/opt/domain/www.**********.nl/HTML/forum/Sources/BoardIndex.php ln 248)

2: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
(/opt/domain/*********/HTML/forum/Sources/Admin.php ln 75)

And go on,

Can someone please help me, many people are counting on a forum tomorro.

[[Unknown]]

I'm afraid I'm having a lot of trouble understanding you.

What does phpBB have to do with any of this?

Are you a native Dutch/Nederlands speaker (guessing from your .nl)?  There is a support board for other languages - I mention this only because I am having trouble understanding you (I have gone from thinking you were coming from YaBB SE, to YaBB, to phpBB......)

The forum you began with today... was it YaBB SE (http://www.yabbse.org/community/index.php) or YaBB (http://www.yabbforum.com/community/)?

Either way, a link would be useful.  The error message you sent me via pm earlier tonight suggested that you were trying to use the YaBB -> YaBB SE converter.  You also sent me an error message indicating that you were trying to upgrade YaBB SE 1.4.x to SMF.  Given those error messages, I can tell for sure that's what was being done.

The end result is simply my confusion.  I really don't know what you're trying to do, at this point.

-[Unknown]

[Nederland]

I am from the nethelands yes,

Okay this is what i wanted to do,

I had yabb SE instaled on my forum. www.nieuwrechts.nl/forum,  Some files were out of date but couldn't be upgraded anymore because the yabb se project became simple machine's.

So i used the upgrade file and follow'd the guide on this forum to do the upgrade it step by step.
You know what erors i got then... So because some files wer out of date i toucht you told me to up date them first by using the yabb converter. But the yabb converter just returned to te beginning over and over again. So then i tried to upgrade it once more and i got the same errors.

After you told me that you had gone home i was confused doing all thing at the same time..  So i backup'd the stuff at that moment and put down the old forum on the same place as it was. I backe'd up my msqel with gzip and restored that also. But know i got the Where1 error or something in that direction.

I hope you understand it all better now...

I am thankfull for any help you can give me..

And sorry if my englisch isn't that good. But i am all stressed.

[Nederland]

These are three errors i got at hand

2: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
(/opt/domain/www.nieuwrechts.nl/HTML/forum/Sources/BoardIndex.php ln 248)


2: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
(/opt/domain/www.nieuwrechts.nl/HTML/forum/Sources/Display.php ln 604)


2: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
(/opt/domain/www.nieuwrechts.nl/HTML/forum/Sources/Admin.php ln 75)


The search option works good, the clander works good, the profile option works good, but at the admin option i get an error.

[[Unknown]]

Sorry for the confusion.

Please use this:

http://prdownloads.sourceforge.net/yabbse/yabbse_1-5-5_upgrade.zip?download

To upgrade from YaBB SE 1.4.x to 1.5.5.

After that's done, please try using the upgrade from this site again.

Hope that's helpful.

-[Unknown]

[Nederland]

It all worked at the first page except for

This is the error i get at the first page.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /opt/domain/www.nieuwrechts.nl/HTML/forum/upgrade.php on line 469
Error: MySQL said:

Key column 'month' doesn't exist in table


At the second page i got this.

Data inserted successfully!

Data inserted successfully!

Data inserted successfully!

Data inserted successfully!

Error: MySQL said:

Duplicate entry 'enableEmbeddedFlash' for key 1
Data inserted successfully!

Data inserted successfully!

Data inserted successfully!

Error: MySQL said:

Unknown column 'identity' in 'nrf_log_online'
Error: MySQL said:

Key column 'identity' doesn't exist in table
Fixing Settings.php...

Warning: fopen(./Settings.php): failed to open stream: Permission denied in /opt/domain/www.nieuwrechts.nl/HTML/forum/upgrade.php on line 441

Warning: fputs(): supplied argument is not a valid stream resource in /opt/domain/www.nieuwrechts.nl/HTML/forum/upgrade.php on line 442

Warning: fclose(): supplied argument is not a valid stream resource in /opt/domain/www.nieuwrechts.nl/HTML/forum/upgrade.php on line 443
done.




And when i enter www.nieuwrechts.nl/forum now it doesn't excist anymore.   

[[Unknown]]

Now please try running the SMF upgrade.php and everything... don't worry, the things that failed shouldn't be a problem.

-[Unknown]

[Nederland]

Okay, this time i did everything by the book and i still got errors.

I started with my fresh backup of yabbse, then i uploaded the new se and i got the same errors.
So i uploaded the upgrade version to SMF and i get this error.

Backing up "log_topics"... done. Incomplete.

Then i push on continue and then i got this errors.

Upgrading...
Backing up old table data...
   Backing up "membergroups"... done.
   Backing up "members"... done.
   Backing up "messages"... Unsuccessful!
This query:
CREATE TABLE backup_nrf_messages (
PRIMARY KEY (`ID_MSG`),
KEY `ID_TOPIC` (`ID_TOPIC`),
KEY `ID_MEMBER` (`ID_MEMBER`),
KEY `posterTime` (`posterTime`))
SELECT *
FROM nrf_messages;
Caused the error:

Table 'backup_nrf_messages' already exists

.... So i think because of my try the last time to upgrade to SMF he made a table in mysqel and it now tells him it is already there. But i am not shure..

I hope you can understand me, and help me...



I also already have the forum up.. But i don't know how.. It is very wrong and it says that i am using an iligal version off SMF because i don't have the copyright on it. But i can't i did not do anything..

[Nederland]

Okay i have everything now but i still can't read the threads in the topics.

Database fout
Unknown column 'lt.ID_MEMBER' in 'on clause'
Bestand: /opt/domain/www.nieuwrechts.nl/HTML/forum/Sources/MessageIndex.php
Regel: 369 



This is when i try to delete a member,

It says database error
Unknown column 'lt.ID_MEMBER' in 'on clause'
File: /opt/domain/www.nieuwrechts.nl/HTML/forum/Sources/MessageIndex.php
Line: 369


And another problem, i set all folders at 777. But i still can't uload attactments.




And i still wonder where my old graphics went.. Can i reload them in the old yabb theme?

[[Unknown]]

The logTopics error, again, is caused by having old tables...

Tell you what, if you'll send me FTP information, I'll see if I can't resolve some/most of your issues.

-[Unknown]