• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Friends Invite Error and scaffolding error!

tosse12

tosse12

Panchira Project Member
Joined
Jun 10, 2007
Messages
864
Reaction score
9
Location
Sweden
Greetings,

I am currently having an error:
Code: 
A PHP Error was encountered

Severity: Notice

Message: Undefined index: account_id

Filename: IDE/main.php

Line Number: 73
And:
Code: 
A Database Error Occurred
Error Number: 1064

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 'AND active = 0' at line 1

SELECT id FROM friends WHERE `with` = 3 AND friend = AND active = 0

I get this error when I am trying to accept a friend invite.

I think I am able to fix this myself but don't have time at moment, gonna go to school in 10 mins.

EDIT:
Okey, I found out that I can accept the invites from outside of the network as the server is in, but in the same network, I am getting this error.

Edit2:
I found a Scaffolding error while updating in the database:
Code: 
A Database Error Occurred
Error Number: 1054

Unknown column 'nameOriginal' in 'field list'

UPDATE `accounts` SET `name` = 'XXX', `password` = 'XXX', `premdays` = '0', `lastday` = '1283151064', `email` = '[email protected]', `key` = 'XXX', `blocked` = '0', `warnings` = '0', `group_id` = '6', `page_access` = '6', `page_lastday` = '', `email_new` = '', `email_new_time` = '', `rlname` = '', `location` = '', `created` = '', `email_code` = '', `next_email` = '', `premium_points` = '0', `nickname` = 'XXX', `avatar` = '', `about_me` = '', `nameOriginal` = 'XXX', `passwordOriginal` = 'XXX', `premdaysOriginal` = '0', `lastdayOriginal` = '1283151064', `emailOriginal` = '[email protected]', `keyOriginal` = 'XXX', `blockedOriginal` = '0', `warningsOriginal` = '0', `group_idOriginal` = '6', `page_accessOriginal` = '6', `page_lastdayOriginal` = '', `email_newOriginal` = '', `email_new_timeOriginal` = '', `rlnameOriginal` = '', `locationOriginal` = '', `createdOriginal` = '', `email_codeOriginal` = '', `next_emailOriginal` = '', `premium_pointsOriginal` = '0', `nicknameOriginal` = 'XXX', `avatarOriginal` = '', `about_meOriginal` = '' WHERE `id` = 'X'

Looks messy I know xD
 
Last edited:
Back
Top