1
Kaahx
Update to 2.1.1 problems
  • 2005/5/21 12:34

  • Kaahx

  • Just popping in

  • Posts: 5

  • Since: 2005/5/21


Hi!

Updated to latest version from 2.0.10, and now the page looks fine but i cant post

I can't save the configuration(blank page when saving), where is the configuration file located so i can give it the write rights?
When i post something in the forum i get Could not insert forum post.

DB error: INSERT photo table <-- when inserting photo in myalbum-p

Going to the admin page gives only the XOOPS logo

2
Mithrandir
Re: Update to 2.1.1 problems

can you go to www.yoursite.com/recovery.php, log in and enable PHP debug?

3
Kaahx
Re: Update to 2.1.1 problems
  • 2005/5/21 12:43

  • Kaahx

  • Just popping in

  • Posts: 5

  • Since: 2005/5/21


Yes.. enabled php debug..

Posting in forum:
Notice [PHP]: Undefined index: nosmiley in file modules/newbb/post.php line 174
Notice [PHP]: Undefined index: icon in file modules/newbb/post.php line 175
Notice [PHP]: Undefined index: attachsig in file modules/newbb/post.php line 176
Notice [PHP]: Use of undefined constant desc - assumed 'desc' in file modules/myguestbook/xoops_version.php line 92
Notice [PHP]: Use of undefined constant desc - assumed 'desc' in file modules/myguestbook/xoops_version.php line 115
Notice [PHP]: Undefined index: name in file kernel/object.php line 283
Notice [PHP]: Undefined index: name in file kernel/object.php line 284
Notice [PHP]: Undefined index: name in file kernel/object.php line 381

Accessing my account
Notice: Undefined index: name in /storage/www/vannasby/kernel/object.php on line 283

Notice: Undefined index: name in /storage/www/vannasby/kernel/object.php on line 284

Notice: Undefined index: name in /storage/www/vannasby/kernel/object.php on line 381

Notice: Undefined index: name in /storage/www/vannasby/kernel/object.php on line 283

Notice: Undefined index: name in /storage/www/vannasby/kernel/object.php on line 284

Notice: Undefined index: name in /storage/www/vannasby/kernel/object.php on line 381

Notice: Undefined variable: xoopsCachedTemplateId in /storage/www/vannasby/footer.php on line 44

I se the object.php error on allmost all the pages :(..
Panic hehe

4
Mithrandir
Re: Update to 2.1.1 problems

Hmmm... the dynamic user profile has not been created properly. I wonder what caused that.

*looking*
Ah yes, I think I know what it was. There was an error in the SQL statement updating the profile.

You did make a backup, right? Because I have now added a safety to the update script in case it cannot move the appropriate user fields over in the new table for dynamic fields so it doesn't remove the fields in the users table (will be available in the CVS nightly tomorrow). However, that will not help you as the damage is done now.

A way to get something working so you can try out some more is to:

1. Open PHPMyAdmin or similar DB admin tool
2. Run this query:
INSERT INTO [prefix]_user_profile (profileidSELECT uid FROM [prefix]_users

replace [prefix] with your database table prefix
3. Edit your account

However, the blank page with the configuration bothers me - could you try saving the configuration again, this time with PHP debug?

5
Kaahx
Re: Update to 2.1.1 problems
  • 2005/5/21 13:32

  • Kaahx

  • Just popping in

  • Posts: 5

  • Since: 2005/5/21


stupid me.. i did only make an file backup.. :/

6
Mithrandir
Re: Update to 2.1.1 problems

well - you have lost the information in the user fields that are now moved to be dynamic fields (all fields except uid, uname, name, email, pass, rank, level and user_avatar), so after performing the 3 steps mentioned, you can edit the account to get those fields filled again.

7
Kaahx
Re: Update to 2.1.1 problems
  • 2005/5/21 13:53

  • Kaahx

  • Just popping in

  • Posts: 5

  • Since: 2005/5/21


ok..
i dont have phpmyadmin, only MySQL administrator.

how do i do that in terminal?

8
Mithrandir
Re: Update to 2.1.1 problems

You just need to find a way to execute this SQL query (directly, but with [prefix] replaced with your own prefix)
INSERT INTO [prefix]_user_profile (profileidSELECT uid FROM [prefix]_users

9
Kaahx
Re: Update to 2.1.1 problems
  • 2005/5/21 14:13

  • Kaahx

  • Just popping in

  • Posts: 5

  • Since: 2005/5/21


It worked now, inserting.
I have alot of work ahead of me :P

10
indream
Re: Update to 2.1.1 problems
  • 2005/5/21 14:55

  • indream

  • Not too shy to talk

  • Posts: 170

  • Since: 2004/9/21


@Kaahx
i'm used a mysqlfront program this.

visit www.mysqlfront.de url and download mysqlfront

Login

Who's Online

235 user(s) are online (158 user(s) are browsing Support Forums)


Members: 0


Guests: 235


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits