Thread: Database access error in aedating4.1.4

Hi

I 've upgrade from 3.1 to 4.1.4 all was fine exept two errors or bugs i don't know yet.
1- when a new member want to achieve his subscription at the end when he will informed to receive an e-mail to activate his acount he receive Database access error however the message is sent and received by member and he can activate his subscription!!!
2- also i've installed new version of flashchat 4.7.9 when i clik in manage modules link to upload fc_aemod Database access error appears another time so members can not chat.

New subscibers receive Database access error they think that their subscription is rejected but realy are subscibed!


i remarque that it happen when i want to execute profile_edit.php and module.php


in bugs e-meil i received
Error in /admin/modules.php: Unknown column 'Type' in 'order clause'
Query: 'SELECT * FROM `Modules` ORDER BY `Type` ASC'

and this one:

Error in /profile_edit.php: 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 'LIMIT 1' at line 1
Query: 'SELECT Picture, Pic_0_addon FROM Profiles WHERE ID = LIMIT 1'

and this one:
Error in /profile_edit.php: Unknown column 'Type' in 'where clause'
Query: 'SELECT `Name`, `FuncUnblock` FROM `Modules` WHERE `Type` = 'chat''

Hi,

We have developed some custom scripts we use in house to upgrade from older versions of aedating to newer aedating and dolphin - to avoid the problems you are having.

But in your case, you need to compare the old tables from your previous aedating release to the new - find the differences - and adjust. Ans your modifications and code base - check them too.

Start with the tables you are having trouble with.

Code:

Error in /admin/modules.php: Unknown column 'Type' in 'order clause'

missing the Type column

Code:

Query: 'SELECT Picture, Pic_0_addon FROM Profiles WHERE ID = LIMIT 1'

ID value for the user was not passed to the query

Code:

Error in /profile_edit.php: Unknown column 'Type' in 'where clause'

missing the Type column

Smoge

Thanks smoge i have changed my modules table by latest i have no this message but when i want to upload fc.aemod i got this message:

Warning: move_uploaded_file(/home/my account/public_html/tmp/module.tmp) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/my account/public_html/admin/modules.php on line 165

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/php6JKOye' to '/home/my account/public_html/tmp/module.tmp' in /home/my account/public_html/admin/modules.php on line 165what's wrong

and how can i got this script wich you are speaking about smoge if i want?

Hi,

Our custom upgrade script is not for sale - we use it only internally when we do aeDating and Dolphin site upgrades for customers.

As for loading the fc.aemod - if you open it in an editor, you will see it is just a bunch of SQL statements - you can load it into your DB directly by copy and pasting it into your phpMyAdmin SQL box.

Smoge

Thanks Smoge
It works now!
I notice also that this version doesn't accept arabic char when i edit articles or polls or events...

Originally Posted by faouzi

Thanks Smoge
It works now!
I notice also that this version doesn't accept arabic char when i edit articles or polls or events...

Is your database (and those tables) setup for UTF8?

Smoge

Yes it is in utf8 but always the same problem