Re: [mezzanine-users] Re: Bulk Product Upload In Cartridge

[ninh2k]

Yes the source expects comma delimited but my data contains commas so I had 
to change it to accept tab delimited.

On Tuesday, August 5, 2014 8:16:56 AM UTC-5, Kenneth Bolton wrote:
>
> You have got this.
>
> According to the source 
> ,
>  
> the file needs to be comma-delimited, not tab-delimited. 
>
> On Tue, Aug 5, 2014 at 8:56 AM, Stevo > 
> wrote:
>
>>
>>  I ran that product_db command with --export and it coughed up a .csv 
>> file full of magic ponies.  I tried to make my upload file the same, but 
>> when I ran the command with --import,  I got this:
>>
>> (mezzcart)hobbo5424@hobbo5424-Inspiron-N4050 ~/mezzcart/proj1 $ python 
>> manage.py product_db --import produpload3.csv
>> /home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/mezzanine/utils/conf.py:92:
>>  
>> UserWarning: mezzanine.pages.context_processors.page is required in the 
>> TEMPLATE_CONTEXT_PROCESSORS setting. Adding it now, but you should update 
>> settings.py to explicitly include it.
>>   "explicitly include it." % cp)
>> Importing ..
>> {'Title\tContent\tDescription\tCategory\tSub-Category\tSKU\tImage\tNumber 
>> in Stock\tUnit Price\tSale Price\tSale Start Date\tSale Start Time\tSale 
>> End Date\tSale End Time': 'Old Boot\tThis brown leather foot covering 
>> will keep your feet warm\tLight tan in colour and buffed to 
>> perfection\tShop\t\t13\tproduct/red.png\t2\t50\t5\t\t\t\t'}
>> Traceback (most recent call last):
>>   File "manage.py", line 29, in 
>> execute_from_command_line(sys.argv)
>>   File 
>> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>  
>> line 399, in execute_from_command_line
>> utility.execute()
>>   File 
>> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>  
>> line 392, in execute
>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>   File 
>> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/base.py",
>>  
>> line 242, in run_from_argv
>> self.execute(*args, **options.__dict__)
>>   File 
>> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/core/management/base.py",
>>  
>> line 285, in execute
>> output = self.handle(*args, **options)
>>   File 
>> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py",
>>  
>> line 94, in handle
>> import_products(csv_file)
>>   File 
>> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py",
>>  
>> line 149, in import_products
>> product = _product_from_row(row)
>>   File 
>> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py",
>>  
>> line 100, in _product_from_row
>> product, created = Product.objects.get_or_create(title=row[TITLE])
>> KeyError: u'Title'
>>
>> This is the same error I got when I tried to import it the first time 
>> before I did the export, so I don't think it's a fault in the text file. I 
>> keep reading nin's answer, but there's no customisation and I made the 
>> column headers the same as those from the export output.
>>
>> So what's my problem? And what's the limit on dumb questions? C'mon we 
>> can do this
>>
>> Best Regards,
>>
>>
>>
>> On Tuesday, August 5, 2014 1:25:53 PM UTC+10, Stevo wrote:
>>
>>>  Ahhh now I get it - thank you!   And thanks for those tute links - 
>>> exactly what I need right now.  The help this group has given is awesome. 
>>> Regards to all!
>>>
>>> On Tuesday, August 5, 2014 1:53:24 AM UTC+10, nin...@gmail.com wrote:
>>>
 Stevo,

 From your mezzanine project directory, 

 ./manage.py product_db --import 

 where datafile is a tab delimited text file.  If you have customized 
 the product table, you need to do same to product_db and make sure the 
 column names the same as the text file with your datafile...

 It's best to test it inside virtualenv.

 On Monday, August 4, 2014 7:43:56 AM UTC-5, Stevo wrote:
>
> Hi Ken, I think you got that right, coz when I tried again my error 
> was different:
>
> File "/home/hobbo5424/mezzcart/local/lib/python2.7/site-
> packages/django/conf/__init__.py", line 47, in _setup
> % (desc, ENVIRONMENT_VARIABLE))
> django.core.exceptions.ImproperlyConfigured: Requested setting 
> INSTALLED_APPS, but settings are not configured. You must either define 
> the 
> environment variable DJANGO_SETTINGS_MODULE or call settings.configure() 
> before accessing settings.
>
> If you could suggest a way to set it up properly, I'd be happy to 
> start over again - I haven't done any real work on the site yet. At this 
> stage, I just need to prove it can be done (by me at least).
> What is supposed to 

Re: [mezzanine-users] Re: Bulk Product Upload In Cartridge

[ninh2k]

Stevo,

>From your mezzanine project directory, 

./manage.py product_db --import 

where datafile is a tab delimited text file.  If you have customized the 
product table, you need to do same to product_db and make sure the column 
names matches with your datafile...
It's best to test it inside virtualenv.

On Monday, August 4, 2014 7:43:56 AM UTC-5, Stevo wrote:
>
> Hi Ken, I think you got that right, coz when I tried again my error was 
> different:
>
> File 
> "/home/hobbo5424/mezzcart/local/lib/python2.7/site-packages/django/conf/__init__.py",
>  
> line 47, in _setup
> % (desc, ENVIRONMENT_VARIABLE))
> django.core.exceptions.ImproperlyConfigured: Requested setting 
> INSTALLED_APPS, but settings are not configured. You must either define the 
> environment variable DJANGO_SETTINGS_MODULE or call settings.configure() 
> before accessing settings.
>
> If you could suggest a way to set it up properly, I'd be happy to start 
> over again - I haven't done any real work on the site yet. At this stage, I 
> just need to prove it can be done (by me at least).
> What is supposed to happen when you run product_db.py? I can't see where 
> or how it would find a .csv file to upload.
> Martin suggested "playing around with Cartridge api within a shell to play 
> around with the product database." I don't know how to do that either.
> Sorry to ask dumb questions, but Ryan said to keep trying and not give up.
> Cheers and thanks!
>
>
> On Sunday, August 3, 2014 10:20:41 PM UTC+10, Kenneth Bolton wrote:
>>
>> sounds like you are running the script possibly with the wrong python, 
>> e.g. without your virtualenv activated.
>>
>> ken
>>
>>
>> On Sun, Aug 3, 2014 at 6:57 AM, Stevo  wrote:
>>
>>> Thanks Ryan! - I tried to run the script from:
>>>
>>> myproject/lib/python2.7/site-packages/cartridge/shop/management/commands/product_db.py
>>> but got an ImportError: No module name mezzanine.conf
>>> I couldn't find anything in the Cartridge docs or in Mezzanine. So is it 
>>> in Django documentation?
>>> Please, could you give me a couple more hints and/or tell me where to go 
>>> for more info on what to do? 
>>> I passed my python MOOC so I've got plenty of time on my hands now. Haha!
>>> Regards, Stevo
>>>
>>>
>>> On Saturday, August 2, 2014 12:54:26 AM UTC+10, Ryan Sadwick wrote:

 I recently made a script that calls Amazon's product api and inserts 
 into cartridge for an affiliate mash up site.  I based the script off of 
 what Stephen linked earlier and the mezz/cartirdge chart: 
 http://cartridge.jupo.org/_images/graph.png.  The most products I've 
 inserted at one time has been around 100 since I'm hand picking the 
 products and I loop through a list of item numbers that call the script to 
 insert into cartridge.

 I didn't run into any problems, everything works - ratings, images, 
 categories.  I'd suggestion playing around with Cartridge api within a 
 shell to play around with the product database.

 I'd suggest to keep at it and don't give up. 

 Ryan

 On Wednesday, July 30, 2014 9:35:35 PM UTC-4, Stevo wrote:
>
> My biggest product feed is JSON and has 20k skus and gets updated 
> every 2 weeks. Other files are .csv, and only 3-4k skus, updated every 2 
> months or so.
> My main needs are: a) quoting tool to guide/train/remind the user on 
> the process and options in quoting complex product bundles  b) large 
> number 
> of products with lots of attributes   c) speed for about 20 users, and   
> d) 
> easy coding to suit my high-level noobosity. 
> All I've tried so far is doing  Dr Chuck's Python Course 
> , the Django tute 
> , Ross 
> Laird's tutes 
>  and 
> installing Mezzanine  and trying out 
> python-docx  (How 
> cool is that gizmo?)
> Like Mike, I love Mezzanine "out-of-the-box" plus its 
> not-insurmountable learning curve. I've had a look at OpenERP, Magento, 
> SugarCRM and vTiger and a few others. They all do a great job, but the 
> complexity of all that functionality is a problem for a web-admin person 
> in 
> a team of one, like me. So maybe it's better to do a bit of coding to get 
> one app to do more, rather than manage three apps from the admin 
> interface 
> and try to get them to talk to each other.
> My thinking is to use Mezzanine as a kind of "intranet-hub" to other 
> apps, like the quoting tool. Or actually use Mezzanine and Cartridge to 
> do 
> the quoting tool itself.  So I was just hoping for some advice before I 
> get 
> started. So if you think it not a dumb idea, I'll try Sam's Way first and 
> report back when I've got some r

Re: [mezzanine-users] User / Group permission to Change Product

[ninh2k]

Thanks Josh for the insight.  It looks like Product would need a user_id 
field in order to inherit from Ownable and will need some good testing to 
make sure not breaking other functions.

On Friday, August 1, 2014 8:32:20 AM UTC-5, Josh Cartmell wrote:
>
> Hey Ninh, this happens because BlogPost inherits from Ownable and the 
> BlogPost admin inherit from the OwnableAdmin.  You may be able to monkey 
> patch this functionality onto Product somehow, but I'm not sure.
>
>
> On Fri, Aug 1, 2014 at 12:39 AM, > wrote:
>
>> Hi, In blog posts, user cannot view or change other users' posts.  Any 
>> pointers to how to make Products works in the same way?
>> Thanks.
>>  
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Mezzanine Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to mezzanine-use...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mezzanine-users] User / Group permission to Change Product

[ninh2k]

Hi, In blog posts, user cannot view or change other users' posts.  Any 
pointers to how to make Products works in the same way?
Thanks.

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [mezzanine-users] ANN: Mezzanine Page Auth 0.1.2

[ninh2k]

Hi Simone, All,

I have tried mezzanine_page_auth to restrict users to access and edit only 
the page assign to the group they belong to,
but it's not working as expected.

For example, I created a custom page type "partners" and gave to Group A 
and Group B "can change partner" permission.  
Then I created partners pageA and assign it to Page Auth Group A,  pageB to 
Page Auth Group B.
The issue is a user in Group A is still able to edit/change pageB.   I 
think that defeats the purpose of page permission?  
Group A users should be able to change only pages assign to Group A, is 
that correct?   
Can you give me some pointers?   Thanks.


On Tuesday, November 19, 2013 2:01:26 AM UTC-6, Dalla, Simone wrote:
>
> 2013/11/19 Stephen McDonald >: 
> > Awesome - I just added it to the third party apps list in the docs, and 
> > Django packages grid: https://www.djangopackages.com/grids/g/mezzanine/ 
> > 
> > Thanks! 
>
>
> Thanks Josh and Stephen for feedbacks! 
>
> -- 
> Simone Dalla 
>
> Responsabile Sistemi Informatici 
> Comune di Zola Predosa 
> Email: sda...@comune.zolapredosa.bo.it  
> Tel: 0516161860 
> Cell: 3290179546 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mezzanine-users] User view only products filter by shop_product column

[ninh2k]

Hi,

I am looking to add some user / group permissions so when logged in, the 
user is limited to view / change only the Products list filter by the 
column value in shop_product table.
e.g. http://.../admin/shop/product/?column_id=XYZ  

and I already updated list_filter in admin.py:

  list_filter = ("status", "available", "categories", "column_id")

Can someone give me pointers please?   Thanks.

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mezzanine-users] NotImplementedError at /admin/shop/product/

[ninh2k]

Hi, has anyone seen the following error when accessing the admin product 
homepage?
Other pages like /admin/shop/product/add  (add product) or  
/admin/shop/product/1  (edit product) work fine.

NotImplementedError at /admin/shop/product/ 

No exception message supplied

Django Version: 1.6.5  Exception Type: NotImplementedError  Exception 
Location: 
/myprojects/EnvProV/lib/python2.7/site-packages/django/db/backends/__init__.py 
in datetime_extract_sql, line 767  Python Executable: 
/myprojects/EnvProV/bin/python  Python Version: 2.7.5


Error during template rendering 

In template 
/home/10019751/myprojects/EnvProVM3/lib/python2.7/site-packages/grappelli_safe/templates/admin/change_list.html,
 
error at line *140*



-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [mezzanine-users] Display available products when price not entered

[ninh2k]

The product is "Available for purchase" with quatity in "Number in stock", 
but the listing displays
"Coming Soon" and  "This product is currently unavailable."
So I have to enter a number in  "Unit Price" to make it available.
If the price is not determined yet, then I have to enter "0".

On Monday, June 30, 2014 8:13:18 AM UTC-5, Josh Cartmell wrote:
>
> I'm not sure what you are trying to accomplish, could you go into some 
> more detail?
>
>
> On Mon, Jun 30, 2014 at 8:12 AM, > wrote:
>
>> Hi,
>> Is there an option to show the available product when the price has not 
>> entered yet?
>> I checked the configuration list and not finding any.   Thanks.
>>  
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Mezzanine Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to mezzanine-use...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mezzanine-users] Display available products when price not entered

[ninh2k]

Hi,
Is there an option to show the available product when the price has not 
entered yet?
I checked the configuration list and not finding any.   Thanks.

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [mezzanine-users] global name 'pytz' is not defined

[ninh2k]

Thanks Stephen, that is the fix I need.

On Friday, June 27, 2014 4:12:39 PM UTC-5, Stephen McDonald wrote:
>
> Looks like a bug recently fixed in django_pyodbc:
>
>
> https://github.com/lionheart/django-pyodbc/commit/df70c8f53f4f01803cb4c4e56e662138a5594b3c
>
> You probably don't have that fix.
>
>
> On Sat, Jun 28, 2014 at 6:01 AM, > wrote:
>
>> Hi,
>> I am looking for the fix to the error below.  I already tried adding to  
>> /cartridge/shop/admin.py:
>>
>> import pytz
>> from django.utils import timezone
>> from django.utils.timezone import utc
>>
>> Also having same error at  /admin/blog/blogpost/
>>
>> Thanks,
>> Ken
>> ---
>> NameError at /admin/shop/product/ 
>>
>> global name 'pytz' is not defined
>>
>>  
>>
>>
>>
>> Django Version: 1.6.5  
>>
>> Exception Value: 
>>
>> global name 'pytz' is not defined
>>
>>  Exception Location: 
>> /myprojects/EnvProVM3/lib/python2.7/site-packages/django_pyodbc/operations.py
>>  
>> in _switch_tz_offset_sql, line 74  Python Executable: 
>> /myprojects/EnvProVM3/bin/python  Python Version: 2.7.5  
>>
>>
>>
>> Error during template rendering 
>>
>> In template 
>> /home/10019751/myprojects/EnvProVM3/lib/python2.7/site-packages/grappelli_safe/templates/admin/change_list.html,
>>  
>> error at line *140*
>>
>>
>> /home/10019751/myprojects/EnvProVM3/lib/python2.7/site-packages/django_pyodbc/operations.py
>>  
>> in _switch_tz_offset_sql 
>>
>> if pytz is None:
>>
>>
>>  -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Mezzanine Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to mezzanine-use...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Stephen McDonald
> http://jupo.org 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [mezzanine-users] global name 'pytz' is not defined

[ninh2k]

I am running in virtualenv and pytz installed and on pip freeze list.

On Friday, June 27, 2014 3:48:18 PM UTC-5, Josh Cartmell wrote:
>
> I would guess that running:
> pip install pytz
>
> will fix your problem.
>
>
> On Fri, Jun 27, 2014 at 4:01 PM, > wrote:
>
>> Hi,
>> I am looking for the fix to the error below.  I already tried adding to  
>> /cartridge/shop/admin.py:
>>
>> import pytz
>> from django.utils import timezone
>> from django.utils.timezone import utc
>>
>> Also having same error at  /admin/blog/blogpost/
>>
>> Thanks,
>> Ken
>> ---
>> NameError at /admin/shop/product/ 
>>
>> global name 'pytz' is not defined
>>
>>  
>>
>> Django Version: 1.6.5  Exception Value: 
>>
>> global name 'pytz' is not defined
>>
>>  Exception Location: 
>> /myprojects/EnvProVM3/lib/python2.7/site-packages/django_pyodbc/operations.py
>>  
>> in _switch_tz_offset_sql, line 74  Python Executable: 
>> /myprojects/EnvProVM3/bin/python  Python Version: 2.7.5  
>> Error during template rendering 
>>
>> In template 
>> /home/10019751/myprojects/EnvProVM3/lib/python2.7/site-packages/grappelli_safe/templates/admin/change_list.html,
>>  
>> error at line *140*
>>
>>
>> /home/10019751/myprojects/EnvProVM3/lib/python2.7/site-packages/django_pyodbc/operations.py
>>  
>> in _switch_tz_offset_sql 
>>
>> if pytz is None:
>>
>>
>>  -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Mezzanine Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to mezzanine-use...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mezzanine-users] global name 'pytz' is not defined

[ninh2k]

Hi,
I am looking for the fix to the error below.  I already tried adding to  
/cartridge/shop/admin.py:

import pytz
from django.utils import timezone
from django.utils.timezone import utc

Also having same error at  /admin/blog/blogpost/

Thanks,
Ken
---
NameError at /admin/shop/product/ 

global name 'pytz' is not defined

 

Django Version: 1.6.5  Exception Value: 

global name 'pytz' is not defined

 Exception Location: 
/myprojects/EnvProVM3/lib/python2.7/site-packages/django_pyodbc/operations.py 
in _switch_tz_offset_sql, line 74  Python Executable: 
/myprojects/EnvProVM3/bin/python  Python Version: 2.7.5  
Error during template rendering 

In template 
/home/10019751/myprojects/EnvProVM3/lib/python2.7/site-packages/grappelli_safe/templates/admin/change_list.html,
 
error at line *140*

/home/10019751/myprojects/EnvProVM3/lib/python2.7/site-packages/django_pyodbc/operations.py
 
in _switch_tz_offset_sql 

if pytz is None:


-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [mezzanine-users] DatabaseError after altering shop_product.

[ninh2k]

Thanks Josh, I am restarting with adding some fields but not removing any 
current ones.  However I ran into a different issue (global pytz not 
defined) when accessing Products, even without any new fields added.  So 
I'll post in another topic.

On Friday, June 27, 2014 8:16:06 AM UTC-5, Josh Cartmell wrote:
>
> Keywords and gen_description are baked into Mezzanine and present all over 
> the place.  Could you just leave them in the database and not use them?  
> You could even modify the shop admin so they don't show.
>
>
> On Thu, Jun 26, 2014 at 6:09 PM, > wrote:
>
>> Hi All,
>> I removed some fields (keywords_string, gen_description) that I don't 
>> need in shop_product table and got the following error after 'admin' login 
>> and click "Products" menu:
>>
>> DatabaseError at /admin/shop/product/ 
>>
>> ('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 
>> 'keywords_string'. (207) (SQLExecDirectW)")
>>
>>  Request Method: GET  Request URL: 
>> http://ldv-sea-provmweb.chemd.net:8000/admin/shop/product/  Django 
>> Version: 1.6.5  Exception Type: DatabaseError  Exception Value: 
>>
>> ('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 
>> 'keywords_string'. (207) (SQLExecDirectW)")
>>
>>
>>
>> Checking the sqlsrv db, I see the above 2 fields I removed exists in 
>> other tables:   blog_blogpost, pages_page.
>> Not sure how they are related.  Thanks for any pointer / hints to 
>> altering shop_product table.
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Mezzanine Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to mezzanine-use...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mezzanine-users] DatabaseError after altering shop_product.

[ninh2k]

Hi All,
I removed some fields (keywords_string, gen_description) that I don't need 
in shop_product table and got the following error after 'admin' login and 
click "Products" menu:

DatabaseError at /admin/shop/product/ 

('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 'keywords_string'. 
(207) (SQLExecDirectW)")

 Request Method: GET  Request URL: 
http://ldv-sea-provmweb.chemd.net:8000/admin/shop/product/  Django Version: 
1.6.5  Exception Type: DatabaseError  Exception Value: 

('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 'keywords_string'. 
(207) (SQLExecDirectW)")



Checking the sqlsrv db, I see the above 2 fields I removed exists in other 
tables:   blog_blogpost, pages_page.
Not sure how they are related.  Thanks for any pointer / hints to altering 
shop_product table.

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [mezzanine-users] mezzanine-project create_project TypeError

[ninh2k]

Here's the fix for this issue:

Line 1011 In  /usr/lib64/python2.7/optparse.py ,
change from:
   if type(args[0]) is types.StringType:

to:
   if type(args[0]) in types.StringTypes:

Looks like the Windows path would be C:\Python27\Lib\

-Ken

On Monday, June 23, 2014 4:49:31 PM UTC-5, Stephen McDonald wrote:
>
> How did you install Mezzanine?
>
> How did you install Python?
>
>
> On Tue, Jun 24, 2014 at 12:31 AM, pierre-louis GONON <
> pierrelo...@gmail.com > wrote:
>
>> hello i'm getting the same error i'm on virtualenv on Windows 7
>> mezzanine-project my_project returns me :
>>
>> Traceback (most recent call last):
>>   File "C:\Python27\Lib\runpy.py", line 162, in _run_module_as_main
>> "__main__", fname, loader, pkg_name)
>>   File "C:\Python27\Lib\runpy.py", line 72, in _run_code
>> exec code in run_globals
>>   File 
>> "C:\Users\Pirlgon\.virtualenvs\envsitemezz\Scripts\mezzanine-project.exe\__main__.py",
>>  
>> line 9, in 
>>   File 
>> "C:\Users\Pirlgon\.virtualenvs\envsitemezz\lib\site-packages\mezzanine\bin\mezzanine_project.py",
>>  
>> line 22, in create_project
>>
>> help="Alternate package to use, containing a project_template")
>>   File "C:\Python27\Lib\optparse.py", line 1018, in add_option
>>
>> raise TypeError, "invalid arguments"
>> TypeError: invalid arguments
>>
>> can somebody help me pls?
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Mezzanine Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to mezzanine-use...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Stephen McDonald
> http://jupo.org 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [mezzanine-users] mezzanine-project create_project TypeError

[ninh2k]

Yes.  I also get same error without the "-a cartridge" option.

On Friday, June 20, 2014 1:03:52 PM UTC-5, Josh Cartmell wrote:
>
> Is cartridge installed?
>
>
> On Fri, Jun 20, 2014 at 1:31 PM, > wrote:
>
>> Hi, I got the following error and seeking for a solution.  Thanks for any 
>> help / suggestion.
>>
>> (EnvVM2):~/myprojects/EnvVM2> mezzanine-project -a cartridge V2D
>> Traceback (most recent call last):
>>   File ".../myprojects/EnvVM2/bin/mezzanine-project", line 11, in 
>> sys.exit(create_project())
>>   File 
>> ".../myprojects/EnvVM2/lib/python2.7/site-packages/mezzanine/bin/mezzanine_project.py",
>>  
>> line 22, in create_project
>> help="Alternate package to use, containing a project_template")
>>   File "/usr/lib64/python2.7/optparse.py", line 1018, in add_option
>> raise TypeError, "invalid arguments"
>> TypeError: invalid arguments
>>
>>  -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Mezzanine Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to mezzanine-use...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mezzanine-users] mezzanine-project create_project TypeError

[ninh2k]

Hi, I got the following error and seeking for a solution.  Thanks for any 
help / suggestion.

(EnvVM2):~/myprojects/EnvVM2> mezzanine-project -a cartridge V2D
Traceback (most recent call last):
  File ".../myprojects/EnvVM2/bin/mezzanine-project", line 11, in 
sys.exit(create_project())
  File 
".../myprojects/EnvVM2/lib/python2.7/site-packages/mezzanine/bin/mezzanine_project.py",
 
line 22, in create_project
help="Alternate package to use, containing a project_template")
  File "/usr/lib64/python2.7/optparse.py", line 1018, in add_option
raise TypeError, "invalid arguments"
TypeError: invalid arguments

-- 
You received this message because you are subscribed to the Google Groups 
"Mezzanine Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mezzanine-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.