Change Log Updates

[zfi]

I have seen this happen in 4.x when one or more of the database tables have different collation sequence definitions. The error occurs in a SQL query where the query is trying to UNION two subqueries...

[zfi]

I see that new patches were released for vb5 but I am unable to locate the change logs for these updates. The ChangeLog page seems to have gone stale - no updates since October 2014. Where can they be...

[zfi]

It's located in the Admin CP -> Import -> Import User step dialog page. Click on the Action button and the next page will prompt for the number of users to import in each pass.

[zfi]

This might be a dumb observation, but don't we need to rebuild the forum and tread counters after an import? If his data is there, maybe it's just not linked up right.

Of course, I could...

[zfi]

The number of users that can be inported on each pass can be set to whatever number you want. Larger numbers require more memory, but you should be able to do 500 to 1000 at a time with a default configuration....

[zfi]

Sometimes just asking the question causes the answer to come out of hiding. The docs for importing are scattered in several places. There are important bits in several forum posts; embedded in configuration...

[zfi]

I don't if this is the right setting but there is a setting in the ImpExConfig.php file for error logging. The default is 'false'. There is also a impexdebug setting, again defaulted to false.

[zfi]

Can you verify that you can see the database from the MySQL Admin tool (windows) or mysqladmin (*nix). After changing the my.ini, did you restart the mysql instance? These may seem obvious, but can get...

[zfi]

There are actually two date/time data types in SQL Server 2005 and before; smalldatetime, which is accurate to one second and datetime, which is accurate to 3.33 ms. For some reason, my dotnetBB database...

[zfi]

It appears that the strtotime() function used to convert the 'dateline' is getting tripped up with the milliseconds portion of the time stamp returned from the MSSQL database. The function returns a non-zero...

[zfi]

Attachments are on my to-do list as well. What I know so far is that there are file extensions and MIME types that can be defined in the attachment manager. I do not know if impex relys on file extensions...

[zfi]

Thanks for the warning on thread sequencing. The site I am migrating has just under 400k posts in about 30 forums. The sequence issue would have been easy to miss in a sea of data. I have this in my issue...

[zfi]

I completed the import and then ran the 'Rebuild Thread Information" and the "Rebuild Forum Information" from the Maintenance -> Update Counters section of the Admin CP. The Last Post...

[zfi]

epoc dates after conversion

I am running into the same issue where the thread 'last post date' or a user's join date are all appearing as 12/31/1969 11:00 PM. That is probably 1/1/1970...