Got error Unknown column 'gender' in 'field list'
Can I get a fix for this? :p
Starting from which version of Elkarte are you running the upgrade?
Oh, uh... sorry for leaving that bit out. Thought I'd included it. It was from version 1.0.9
hmm.... not sure how that is possible, maybe it run twice?
Anyway, I guess if the issue is only that one editing the file install/upgrade_1-1.php changing:
'debug_title' => 'Converting gender data',
'function' => function ($db, $db_table)
{
$result = $db->query('', '
to:
'debug_title' => 'Converting gender data',
'function' => function ($db, $db_table)
{
return;
$result = $db->query('', '
this simply skips the step.
BTW, before doing that, try simply renaming the directory "install" to "install_bak" and see how the forum looks like.
@Spuds any idea how this is possible? As far as I can see from the upgrade script, we do not even drop the column after the upgrade... O_O
The only way I see not to have the gender column is to be running the upgrade on a 1.1 clean install.
Was there a problem along the way of upgrading from SMF and not having that column ... or was that another column that was missing? Just wondering if it was an SMF->ElkArte at some point. Other than that, unless it was manually removed I don't see how it could be missing from 1.0.x
Nope, no SMF->Elkarte migration.
Error popped, as follows:
Error!
Error retrieving information on step: Adding new custom field columns (Item: 14)
This is how far it got:
Adding new tables for notifications...done
Update mention logs...done
Splitting email_id into it's components in postby_emails...done
Converting IP columns to varchar instead of int...done
Adding new custom field columns...done
failed
Location data and personal text also caused the same issue. Simply repeated the suggested edits here and I was able to successfully upgrade.
I just pushed to github a new upgrade with some more checks, I forgot to post it here... I'll do it tomorrow morning 1st thing!
If I didn't forgot to mark the topic unread...
Here it is the file and sorry for the late reply. :-[
Ops... but in the upload system... darn!
*shakes his head at
@emanuele *
Okay, the file is up in the above reply:
https://www.elkarte.net/community/index.php?topic=4764.msg34599#msg34599