[SMF Converter] e107 - 0.7.7

Started by JayBachatero, January 10, 2007, 01:26:50 PM

Previous topic - Next topic

slackerpunk

@Jay

thanks appreciate it.... if you can also look at the third item I posted it would be great... but everything works and all pages come out now all I did was go to ADMIN > FORUM MAINTENANCE >

1. Optimize all tables to improve performance.
2. Find and repair any errors.
3. Recount all forum totals and statistics.

and all the pages showed up.

Btw I am really greatful for your converter script thanks alot

JayBachatero

Ok there is a loginname column.  I updated the converter to reflect that.  About the recount stats.  What convert.php are you using?  Are you using the one from Updated Converters List & Support Topics?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk

yeps thats the only one I can find with the latest timestamp June 24, 2007 I compared it with the one from the downloads section and that one seems to be the latest one I used that and I used the sql from page 6 I think

JayBachatero

Use the sql from the first page.  It seems like its not calculating the stats correctly.  I'll look more into it.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk

ok maybe on my other site when I have the time I will finish this one that I just converted.

slackerpunk

#145
@jay

what database version does the this convert to?

1.1.2 or 1.1.3? because seems like the database is 1.1.2 and the version I am using is 1.1.3

reason I ask is because I got this error message:

QuoteCan't create/write to file '/tmp/#sql_161f_0.MYD' (Errcode: 23)
File: /home/pinode1/public_html/smf/Sources/Profile.php
Line: 2576

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

that showed up when I tried to disable this function Receive reply notification only for the first unread reply. on my profile.

it caused the server to die? not sure why my VPS kernelmemsize maxed out and I had to restart it for my website to work

JayBachatero

Try repairing the table.  Also go to Admin > Forum Maintenance and check for errors.  If I remember correctly there are no database changes in 1.1.3.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

slackerpunk

hmm thats weird


QuoteCongratulations, no errors found! Thanks for checking.

after checking for errors

russia213

QuoteConverting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.user_loginname, 1, 80) AS memberName,
u.user_join AS dateRegistered, u.user_forums AS posts,
(CASE WHEN u.user_admin = 1 THEN 1 ELSE 0 END) AS ID_GROUP, u.user_lastvisit AS lastLogin,
SUBSTRING(u.user_name, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd,
SUBSTRING(u.user_email, 1, 255) AS emailAddress, 0 AS gender,
ue.user_birthday AS birthdate,
SUBSTRING(REPLACE(ue.user_homepage, 'http://', ''), 1, 255) AS websiteTitle,
SUBSTRING(ue.user_homepage, 1, 255) AS websiteUrl,
SUBSTRING(ue.user_location, 1, 255) AS location,
SUBSTRING(ue.user_icq, 1, 255) AS ICQ,
SUBSTRING(ue.user_aim, 1, 16) AS AIM,
SUBSTRING(ue.user_msn, 1, 255) AS MSN, u.user_hideemail AS hideEmail,
SUBSTRING(u.user_signature, 1, 65534) AS signature,
CASE
WHEN SUBSTRING(u.user_timezone, 1, 1) = '+'
THEN SUBSTRING(u.user_timezone, 2)
ELSE u.user_timezone
END AS timeOffset,
SUBSTRING(u.user_image, 1, 255) AS avatar,
SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
SUBSTRING(u.user_ip, 1, 255) AS memberIP,
SUBSTRING(u.user_ip, 1, 255) AS memberIP2, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS messageLabels, '' AS personalText, '' AS YIM,
'' AS timeFormat, '' AS secretQuestion, '' AS secretAnswer, '' AS passwordSalt,
'' AS validation_code, '' AS additionalGroups, '' AS smileySet
FROM `angryunlimited_all`.e107_user AS u
LEFT JOIN `angryunlimited_all`.e107_user_extended AS ue ON (ue.user_extended_id = u.user_id)
WHERE u.user_id != 0
LIMIT 0, 500;
Caused the error:

Unknown column 'ue.user_birthday' in 'field list'

Ummmmmmmmmmmmm... help?

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

mitooz

I have the same problem as russia213,Tried it with the SQL in the first post.
Any idea how to fix this?

mitooz

I fixed that now I get


Converting ranks...Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts (step 2)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting moderators... Successful.
Converting banned users... Successful.
Converting smileys...
Fatal error: Call to undefined function: copy_smileys() in /home/warriors/public_html/convert.php(665) : eval()'d code on line 22

JayBachatero

#152
Download the latest convert.php file.  Updated Converters List & Support Topics
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

nelram

ALTER TABLE `quuqorg_test`.smf_smileys
ORDER BY LENGTH(code) DESC;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2

My servar work on Mysql v. 5.0

How can fix that problem

JayBachatero

In convert.php

Find:
ORDER BY LENGTH(code) DESC;

Replace:
ORDER BY code DESC;
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

milija

I still have problem with

Converting ranks...Converting groups... Successful.
Converting members...Unknown column 'ue.user_birthday' in 'field list'

How to solve this?

JayBachatero

Need to enable the extended profile.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

tcbflyr

Quote from: JayBachatero on February 20, 2008, 01:52:55 PM
Need to enable the extended profile.

I'm getting the same error
Converting ranks...Converting groups... Successful.
Converting members...Unknown column 'ue.user_birthday' in 'field list'

Can you explain your solution, for the computer illiterate (stupid)

JayBachatero

#158
My solution was that.  Enable the extended profile.  What version of e107 are you running?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

tcbflyr


Advertisement: