DB Error: constraint violation?

[3x-a-D3-u5]

i need this site up and running in about 3 days and now this happends.... anyone got some thorts? i have uploaded a new version of Mpix and still the same promlem, i did have a preveous installation of the same version working fine all help would be appreciated!!! this is the error i get

The following unexpected error occurred:
Database Error: DB Error: constraint violation(insert into `mp_regions` set `grid_id`='1',`user_id`='1',`x`='230',`y`='50',`wi dth`='50',`height`='50',`image`='�PNG\r\n\Z\n\0\0\ 0\rIHDR\0\0\02\0\0\02\0\0\0�]�\0\0OIDATX���_h[��?�laǎ� %�Eqb��Q6��X&�RXV]� �R�����}ڊ�֗��↌\\�݇�&٠C �xS�����>t�#\ZK�l�H���w���OWܴ>\\Ľ�{��}���;�(/�L&��X�Z\n�A��\n��\'ڥM!�Y��!�Y��p\0�#��>��y:-\0�ŢK��U��i���t6�w:O��v���KMP;Z�K=��#D���/L�q�,��f2�W�ו���f���i+?z�0 p7�;�XC��W�l�?Yt9=�֖q�,���萦ÃÃâ€*’à ƒÆ’‚¢Ã¢ââà ¢â‚¬Å¡Ã‚¬Ã…¡Ã‚¬Ãà ¢â‚¬Å¡Ãƒâ€šÃ‚¹�\rn�D�n����q\r� �p849 tu18H2YBB�ˑ���$��tu
�&\'W�a\r-s�U\"�/���?16V�Cʭr���`�|�\\��/���ÃÃâ€*’Ãâ€Â*â€â⠀žÂ¢ÃƒÆ’ƒÂ¢Ã¢â€šÂ ¬Ã‚¡�z�ةȯO�
^/^oG\ZYD�\\Yae`�n��?�ǯ^m=x�L��:3���\'F������
ÃÃâ€*’Æ*’ÂÃâ⠂¬Å¡Ãƒâ€šÃ‚®r^^��m�T�륣 �X�����3�[������m���I�t|>��� 1�ɨ����W?���N��믗%�S4�f�[��.��}��s���g���2���u����^.��vRY�|K^��� @hrrs}]
V �����`�&~�[�/�ۭ�iWg���eD�\\�ÃÃâ€*’ââ ‚¬Å¡Ãƒâ€šÃâ €šÃ‚£G\0g���m�`��0=\r�o��[p�,{���1=\r��Y[�P
��Ak����3,޸Q�7�\Zߞ��\"�B��\\��<^��k�p��ۍ)w��B���]����k�t���$�x\\����B;�<��%�]45Y�C�|fJ�����ˍ\r �D��\r�<�#\'�6����)���E,�H�Ӏ��\"�1��\"Ҕ�?�em\n; Х��Έ�f�� c���OC���KC~?�X4r玽��ɥ��P�}�\n�r��w/�K��=\'O���CCܿ_�nc��!# ������i��H�\n���34��LQ���x��y�Q����d��y\0l6���� ���y������-<ؿ��\r�<
����in6f}��y��SD�����X)J!����S��0�*d&)AK�ŋ=ʇr�,\'NX�����w�����G\0��w?�w��bt�cnjA �����9����fW�`LL\0���-�t*��hi)�NjȞ=�B�#�\n$����Wy�%>����9~�BM԰������=�|���*�$*�>��W>H���ӧe5-HT�I9�r����gt�HS���`���B�>����RF�v���*��,_}���\"����k;5�9$�cK�)���\Z��rPڗ����:���ix�`��j�Fi j\"dxXW$>~��\0=M�
��/]��� �Jsj��v�<�\'2��_�d�\Z���3��$b�SyIWeu��(��lP�tz\\�g�D*e �e��ݤ�ln8��dh�\08��4��,\0��zh �R��WYY��ωD��L�*G�ÃÃâ€*’âà ƒÂ¢Ã¢â‚¬Å¡Ã‚Â¬Ãƒâ€šÃ‚Â¦ÃƒÆ’Ã†â€™ÃƒÂ¢Ã¢â€šÂ¬Ã…Â¡ÃƒÆ ’‚¾ %ZsŐT>檡eY���7����([#;#Zȇ&\'ÃÃâ€*’Ãâ€Â*â€â†žÂ¢ÃƒÆ’ƒÂ¢Ã¢â€šÂà ‚¬Ãƒâ€šÃ‚¹��ێ��ޓ����F[&Ӵ����_,�:tHo�
�$� ���a��ʳ�\r����~ϩS8����ƭ[��mG�����-��f+���� �1�փ(�v�pk��o������M�3y�0�>�S��XG�͛�||��k��P\'�o)����+�!wt!r�t% ]]ln��OU��3:ފ5�ҍ.�rww�����Aռ���++?�
^uH��Ѥ��6�� Lf�d��4�j�A���pXM�3�ȣЗ7o<�^�V<�w�T���yse�^�a�k���7W8�[#5��5c�>9R�ĝي��Ő\rps�K�w@��E6��+WdO��o�
N��7�ϛ\r��5���� y|�ۜ�v*�����Ģ�J\0\0\0\0IEND�B`�',`url`='http://google.co.za/',`title`='Hey guys awsome script',`alt`='halla hello hello ehllo',`email`=NULL,`status`=2,`created_on`='2006-07-05 13:06:46' [nativecode=1048 ** Column 'email' cannot be null])

[ehrichweiss]

`email`=NULL,`status`=2,`created_on`='2006-07-05 13:06:46' [nativecode=1048 ** Column 'email' cannot be null])

I think that last line will make it more clear what to look for.

[3x-a-D3-u5]

yes i see thanks, but what must i do? my email doesn't work is that the problem

"email cannot = null"...

do you no what settings i must put into my config file to get my email workin?
these are my settings at the moment:

// mail settings
define('MAIL_TYPE', 'mail');
define('SMTP_HOST', 'smtp.mail.yahoo.co.uk');
define('SMTP_PORT', '587');
define('SMTP_AUTH', '1');
define('SMTP_USER', 'pkresfelder');
define('SMTP_PASS', 'mypassword');
define('SM_PATH', '/usr/bin/sendmailc');


are those correct?

regards ex

[ehrichweiss]

I know that unless you are a "premium" member, you won't be able to use yahoo for a smtp server. That's one thing you can look into.

The error *seems* to suggest that there was no email address entered(I'm assuming on a form). If you're sure the email addy was entered then have you changed the source code at all(besides the config.php)??

[3x-a-D3-u5]

well thanks for your help so far, but no i dont think i have changed anything otherthan style.css? and a few templates, but just adding tables and such..

about that premium thing yes i know you need premium but they gave me those settings for 'being such a great custermer' and i have used them in outlook express which does need those similar settings... and it worked perfectly

what other source are you reffering to that may have something to do with the email?

thanking you again
regards ex

[ehrichweiss]

well, it seems that the error is being generated when someone is filling out the form to create a new accnt, upload a pic, etc. I'm wondering if it's possible that the field for the email address got munged or the like. Does it happen all the time or only this once? If just once maybe the email just wasn't entered and it generated an error.

[arthx]

install new version 1.1.1 of the script

- When user accounts enabled, the pixel purchase process would sometimes raise
an error that "email" cannot be NULL. It was also reporting a PHP Notice
about "undefined index email". Fixed.

[3x-a-D3-u5]

awsome didnt know new versions came out that fast but thanks anyway

regards ex