updating the database errors please help

[mikeo64]

I'm trying to update from 3.3.7 to 3.3.9 and am getting an error when I run the update:

Code: Select all

General Error:SQL ERROR [ mysqli ]Unknown column 'pf_phpbb_youtube' in 'where clause' [1054]SQLUPDATE bb_profile_fields_data SET pf_phpbb_youtube = CONCAT('https://youtube.com/user/', pf_phpbb_youtube) WHERE pf_phpbb_youtube '' AND pf_phpbb_youtube NOT LIKE '%youtube.com/%' in file /home/xlg7nh8e25pi/public_html/phpbb/db/driver/driver.php on line 1023

Installing Data: \phpbb\db\migration\data\v33x\profilefield_youtube_update.
Skip “installer.update_filesystem.download_updated_files” task
Skip “installer.update_filesystem.update_files” task
Skip “installer.update_filesystem.show_file_status” task
Skip “installer.update_filesystem.diff_files” task
Skip “installer.update_filesystem.check_task” task
Skip “installer.obtain_data.update_ftp_settings” task
Skip “installer.obtain_data.update_files” task
Skip “installer.obtain_data.file_updater_method” task

[KevC]

It's because you've deleted the youtube field instead of just deactivating it.

Fix here
https://github.com/phpbb/phpbb/pull/6404/files

[Crizzo]

@KevC: This fix is included in phpBB 3.3.9, which he said he uses.

@mike064:
What do you get when you run this SQL command:

Code: Select all

SELECT field_validation FROM phpbb_profile_fields WHERE field_name = 'phpbb_youtube'; 

Assumes phpbb_ as your database prefix. You need to run this within your phpBB-database, e.g. via phpmyadmin-SQL-tab.

[mikeo64]

@ kevc, never deleted anything. I don't ever remember seeing anything about youtube on the forum.

@mike064:
What do you get when you run this SQL command:

Code: Select all

SELECT field_validation FROM phpbb_profile_fields WHERE field_name = 'phpbb_youtube'; 

Assumes phpbb_ as your database prefix. You need to run this within your phpBB-database, e.g. via phpmyadmin-SQL-tab.

How do I Run the SQL command. I'm stupid when it comes to this stuff. I was fine to set it up, and do updates so long as there aren't any hickups.

[mikeo64]

a little goolge'ing and I think I found something. hopefully it's what you are talking about.

in PHPmyadmin I found SQL. pasted your code in there and hit go.

it says: #1146 - Table 'i4493524_bb2.phpbb_profile_fields' doesn't exist

here's a screen shot:

[Noxwizard]

For yours, the query should be:

Code: Select all

SELECT field_validation FROM bb_profile_fields WHERE field_name = 'phpbb_youtube'; 

[mikeo64]

came back as an empty result set:

[mikeo64]

what does "empty set result" mean and how can I get the new update to go through with this error.

Thanks

[stevemaury]

Try this - https://github.com/phpbb/phpbb/pull/6404/files

[FlaSerIC]

Or try adding the youtube field manually before the update? viewtopic.php?t=2631976

[mikeo64]

Stevemaury, I have no idea what your trying to tell me in that fix. looks like I need to go edit some file in the data base?

FlaSerIC, Try what exactly....I have custom data fields but they have nothing to do with youtube. We don't use yourtube at all on our forum. never had a custom field with youtube (ours are for data like a birthdate, employee number, etc)

[Noxwizard]

phpBB added a Youtube profile field in 3.1.0. If you don't have one, it's because you deleted the profile field. The 3.3.9 update is supposed to ignore this change if it doesn't find the field though (3.3.8 was missing this check).

The link provided by KevC and stevemaury is intending for you to check that you have the corrected update file.
Open: phpbb/db/migration/data/v33x/profilefield_youtube_update.php
Verify: Line 33
Expected: return !$row || $row['field_validation'] === $this->youtube_url_matcher;

If that line doesn't match, replace it with the posted line.

If it does match, you can use what FlaSerIC posted and remake the profile field before attempting the update.

[mikeo64]

ok, got it to work. Thank you all for the help and patience as I hobbled through it.

[genshijin]

This was supposed to be fixed in 3.3.9 from 3.3.7 but still error messages.

General Error:SQL ERROR [ mysqli ]Unknown column 'pf_phpbb_youtube' in 'where clause' [1054]SQLUPDATE phpbb_profile_fields_data SET pf_phpbb_youtube = CONCAT('https://youtube.com/user/', pf_phpbb_youtube) WHERE pf_phpbb_youtube '' AND pf_phpbb_youtube NOT LIKE '%youtube.com/%' in file /****/****/public_html/phpbb/db/driver/driver.php on line 1023

We were told then to reinstall 3.3.7 and wait for 3.3.9 release... here it is and still the same error.

[warmweer]

...
here it is and still the same error.

And the posts with the solution as of the 3.3.8 release are still (AFAIK) present on this board, in fact on this forum.
BTW reinstalling 3.3.7 will NOT bring your board back, but I suspect you meant restoring your 3.3.7