« Importing member fields into members.data?
Database permissions
importer MySQL bug »

havok

  • Posts: 29
Re: Database permissions
« Reply #15, on January 30th, 2014, 10:46 PM »
myphpadmin does not have the option to grant any privileges, restricted by the host because i am on a budget shared hosting blah blah according to online support
option 1 is to switch hosts (any suggestions)
option 2 is there a way to manually transfer the members and other important settings only without importer
option 3 send password reset to all members and start afresh.



Nao

  • Dadman with a boy
  • Posts: 16,079
Re: Database permissions
« Reply #16, on February 2nd, 2014, 12:58 PM »
Hopefully split everything into this topic correctly.
Needs attention, I think!

TE

  • Posts: 286
Re: Database permissions
« Reply #17, on February 2nd, 2014, 02:59 PM »
There's an easy solution: Install both forums (SMF and Wedge) in the same database. They use different prefixes (SMF tables start by default with smf_ and Wedge tables start with wedge_ by default.

Thorsten "TE" Eurich - Former SMF Developer & Converters Guru

havok

  • Posts: 29
Re: Database permissions
« Reply #18, on February 2nd, 2014, 08:44 PM »
:cool:
putting smf and wedge in the same data base worked fine. thank you very much @TE .

Nao

  • Dadman with a boy
  • Posts: 16,079
Re: Database permissions
« Reply #19, on February 3rd, 2014, 01:35 PM »
It's a cop-out! :lol:

Although, yeah, my problem is that I've never tried installing Wedge on a different database, because, well, I only have the one... :^^;:
Also, one would think that if you're thinking of 'upgrading' your forum to Wedge, you'd want to keep changes to a minimum, so... Same database, really.

eolith

  • Wanting to get Wedge on my forums!
  • Posts: 28
Re: Database permissions
« Reply #20, on February 13th, 2014, 05:04 AM »
Importer failed with the same error for me (hosting with GoDaddy), so I installed into the same database. The importer worked in many places, but missed several boards. I got errors on the attachments and other places. Because it only offered a "Try Again" button, I'd advance the substep numeral to continue.

I used the SMF2 .xml file.

Nao

  • Dadman with a boy
  • Posts: 16,079
Re: Database permissions
« Reply #21, on February 13th, 2014, 07:38 AM »
You should post screenshots of your latter errors.

Tipping @TE.

eolith

  • Wanting to get Wedge on my forums!
  • Posts: 28
Re: Database permissions
« Reply #22, on February 13th, 2014, 11:04 PM »Last edited on February 13th, 2014, 11:22 PM
Importer01.png = All checkboxes selected during setup.


First Error comes after the pause, and this is the URL:
http://www.exile-guild.com/wedge/import.php?step=1&substep=3&start=500

ImportAttachmentsError01.pdf = First error during importing attachments.

Now, since there's a If I advance the URL to:
http://www.exile-guild.com/wedge/import.php?step=1&substep=3&start=501
I get the same error, but the error is now "Duplicate entry '1122' for key 1."

so I tried advancing the start # a couple more times, the entry number increases accordingly. However, the last number "1415" remains the same. So I advanced the start value to 620 (which should be the last one). No error resulted.

No further errors. Last time I advanced the substep and got two errors.

Also, on all 3 import attempts, the import.php file is not removed upon checking the box. This does not work during the forum software install, either.

Importer02.png shows the checkbox selected, and Importer03.png shows the forum software finding import.php

So it seems advancing the start value made all the difference, I now have an exact number of topics and posts, however I have one extra member, so I'm thinking that's the auto-created admin account.

📎 Importer01.png - 56.06 kB, 540x933, viewed 200 times.

📎 ImportAttachmentsError01.pdf - 4152.02 kB, downloaded 89 times.

📎 Importer02.png - 11.26 kB, 1074x162, viewed 203 times.

📎 Importer03.png - 2.43 kB, 299x110, viewed 176 times.

Pandos

  • Living on the edge of Wedge
  • Posts: 635
Re: Database permissions
« Reply #23, on February 14th, 2014, 12:11 AM »Last edited on February 14th, 2014, 12:20 AM
The duplicate entry thingy is perhaps easy to solve.
Just edit in import.php line 1384 and adjust the limit to a treshold of 200 instead of 500.
Also it's recommended to lift up your server timeout settings in PHP.


If the duplicate error is persistent, then put the next higher value +200 .
Re: Database permissions
« Reply #24, on February 14th, 2014, 12:12 AM »
Please report if this solved your problem.
# dpkg-reconfigure brain
error: brain is not installed or configured

Nao

  • Dadman with a boy
  • Posts: 16,079
Re: Database permissions
« Reply #25, on February 14th, 2014, 12:45 AM »
+1.

Also, if file can't be deleted with a click, you should check that your folder permissions (chmod) are okay.
« Importing member fields into members.data?
importer MySQL bug »